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 17:36:02
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:
01052602
Views:
8
>Sergey,
>If I run those statements:
>
>csql = "select * from prestacoes where data_venc >= '2005/09/23'"
>csql = "select * from prestacoes where data_venc <= '2006/02/28'"
>
>It returns this message:
>"The conversion of char data type to smalldetime data type resulted in an out-of-range smalldatetime value"
>

It should wor the way it's. You can use SPT parameters as Cetin suggested or try
csql = "select * from prestacoes where data_venc >= '2005-09-23'"
csql = "select * from prestacoes where data_venc <= '2006-02-28'"
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform