|
| |
|
|
oriscus
Posts: 47
Joined: 2/5/2002
From:
Status: offline
 |
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
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
