Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lookin' for a DATE() function, for an index that is...
Message
From
29/09/2006 11:55:50
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Lookin' for a DATE() function, for an index that is...
Miscellaneous
Thread ID:
01158164
Message ID:
01158164
Views:
66
Hi All:

I'm porting my app from VFP 7 to 9, and one index key (reference+DTOC(date)) I have set up generates an 'error building key index' when I try to insert (date) value (date()). The strange thing is that if I open the table and just do a reindex, it works fine but if I run it through Stonefield's reindex proc, I get the error. I know I shouldn't be using DTOC, and the strictdate setting doesn't have any effect.
Should I change the index or SDT or both, or do something else altogether?

Thanks
Luke
Next
Reply
Map
View

Click here to load this message in the networking platform