Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange Index Error
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01571265
Message ID:
01571266
Views:
62
>Here is the index key Unassdoc
>
>“DTOC(when_sent)+doctor_last_name” (when_sent is a datetime field) (doctor_last_name is C(35))
>
>And the Filter is “status = 5” for this key
>
>There are NO Memos in this key.
>
>I can go in and Rebuild Indexes, and sometimes this fixes it. Then when I run the code, the error reoccurs.
>
>
>Since there are NO Memors, then why would the error occur.

Don't use DTOC function in the index. Use DTOS() instead. Check DTOC() in Help as to why (you can use it with second parameter).
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform