Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exact OFF Strrange Behaviour
Message
From
23/12/2003 03:42:15
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00861443
Message ID:
00861520
Views:
20
Hi Hani

If the select statement you have written is correct, you are actually asking for ALL records! PLease drink a cup of coffee, and reread it.

*I am using SQL Statement which brings more records than I need because it behaves like SET EXACT OFF, here is my statement
*SELECT code from items where alltrim(code) >= '140' and alltrim(code) <= '140'
*The Result sets contains records for item = '140' and item = '1404'
*I even tried to set exact on but with no change.
*Any Help on that
Previous
Reply
Map
View

Click here to load this message in the networking platform