|
oriscus -> Using a delimited text database (10/10/2002 13:59:17)
|
I' ve created a read-only Access database to use with a DRW search form. No problem. Now I need to make it work, not as an Access file, but as a delimited text file that can also be acted upon by a CGI script to be developed later by someone else. I' ve used Access to export it to a tab-delimited file with fieldnames in the first line. When I went to the DRW, it told me to create a Schema.ini file. I looked into that and I think I did what was required. Now when I go to the DRW it makes the database connection, lets me create a custom query, then when Edit List of fieldnames in the DRW (Step 3) there' s nothing to select. Any ideas?
The database is a text file at: http://www.oriscus.com/khs/markersdb.txt
The Schema.ini file states:
[markersdb.txt]
Format=TabDelimited
ColNameHeader=True
Col1=number short
Col2=title longchar
Col3=location longchar
Col4=county text
Col5=descr1 longchar
Col6=descr2 longchar
|
|
|
|
