Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's wrong with this statement in SQLEXEC( ) ?
Message
De
23/09/2005 18:37:51
Peter Wagner
Point Informática Ltda.
Limeira, Brésil
 
 
À
23/09/2005 18:27:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Divers
Thread ID:
01052565
Message ID:
01052604
Vues:
10
Fabio,
thanks !
So simple and I didn't see it ..

[ ]'s
Peter

>>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"
>>
>>How to solve this problem now ?
>>
>>Peter
>>
>
>
>
>csql = "select * from prestacoes where data_venc >= '20050923'"
>csql = "select * from prestacoes where data_venc <= '20060228'"
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform