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 16:55:49
Peter Wagner
Point Informática Ltda.
Limeira, Brésil
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
What's wrong with this statement in SQLEXEC( ) ?
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Divers
Thread ID:
01052565
Message ID:
01052565
Vues:
50
Hi, it's friday and I'm going crazy with a simple SQL statement.
csql = "select * from prestacoes where data_venc >= 2005/09/23"
a = SQLEXEC(nID,csql,"resultado")
returns the data from SQL server as expected
But, if I run this one:
csql = "select * from prestacoes where data_venc <= 2006/02/28"
a = SQLEXEC(nID,csql,"resultado")
Returns no record

But if I run those same statements in QA, I get the data as expected in both cases.
Why when I use "<" ou "<=" I dont get those values that exist in table prestacoes.

TIA
Peter
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform