Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's wrong with this statement in SQLEXEC( ) ?
Message
 
To
23/09/2005 19:12:15
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01052565
Message ID:
01052621
Views:
7
>George,
>thanks but when I run this statement it also returns the same erro message as it returned for Sergey.
>"The conversion of char data type to smalldetime data type resulted in an out-of-range smalldatetime value"
>It seems to me that it's necessary remove the slash "/" from the date to make it work.

It may be that you've indicated that the date seperator is a hyphen (-) rather than a slash in the SQL Server options.
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform