Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error#2034 Date/DateTime evaluated to an invalid value
Message
 
 
To
14/07/2009 05:52:06
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01411068
Message ID:
01412177
Views:
54
>Naomi,
>
>RE:You should never use DTOC() without second parameter in the Index expression. It's better to use DTOS() function to sort dates properly. Check Help on DTOC() why it can not be used in indexes.
>
>Thanks for the heads up on that - apparently we had a couple of indexes like that - we only had them for rushmore optimization so when we did a delete tag on them it seemed to resolve these errors. The other indexes were using DTOS() thankfully. Thanks again for all your help!
>
>From: Ed

You're welcome.

BTW, in the Message view setup (top right corner of the message) you can enable auto-quote.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform