Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending to FP Dos table from VFP
Message
From
02/02/2000 16:12:38
 
 
To
02/02/2000 15:24:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00326352
Message ID:
00326395
Views:
24
>Hello,
>I have to append records to a FoxPro Dos table.
>Some problems did occur which we weren't able yet to identify.
>One question:
>How are indexes handled when appending to a Dos table? The table in question has an index on DTOC(datefield)+CharacterField. Can this cause problems? Are there more secure ways of exporting records to a DOS table?

You would probably be better off with DTOS(datefield)+CharacterField, if the purpose of the index is to order the records by date. It would also work well for lookup purposes, and is not affected by SET CENTURY ON/OFF.
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform