Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql curiosity
Message
 
 
À
18/03/2010 05:26:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01455308
Message ID:
01455329
Vues:
47
>I use a prg containing only app. 20 select queries.
>They give the right results except the one I enclosed.
>It results 0, which obviously false.
>The interesting thing is that when I make a selection of the
>code snippet enclosed and click on "Execute selection", it gives the right result.
>Any idea?
>
>
>lcDateInd = {2010.01.01 00:00:00}
>lcDateErk = {2010.02.01 00:00:00}
>lcDateStor = {2000.01.01 00:00:00}
>
>
>SELECT count(bp_eng_uh.engkod) as db;
>from bp_eng_uh;
>where bp_eng_uh.alairva >= lcDateInd;
>AND bp_eng_uh.alairva < lcDateErk;
>AND bp_eng_uh.stornozva < lcDateStor;
>into cursor osszesUH
>
>
Since you're passing datetimes, it will make more sense to name the variables as

ltDateInd = datetime(2010,1,1)
ltDateErk = datetime(2010,2,1)
ltDateStor = datetime(2000,1,1)

Also, could it be different SET DELETED setting affecting the output ?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform