Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql curiosity
Message
From
18/03/2010 05:26:03
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Sql curiosity
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01455308
Message ID:
01455308
Views:
128
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
Next
Reply
Map
View

Click here to load this message in the networking platform