Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why my SQL gives me wrong results
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01140687
Message ID:
01140704
Views:
14
>Hello again
>
>No, still getting the same results and still not restricting to only one operator. :-(

Put all Dates in where clause in ( ) and leave AND outside them:
WHERE (............) AND op.Code == lnOpCode
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform