Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select problem
Message
From
16/04/2007 12:02:01
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Select problem
Miscellaneous
Thread ID:
01216288
Message ID:
01216288
Views:
63
I declare statement
strSel = "J.number >'"+ pStartNo +"' and J.number <='" + pEndNo + "'"

run the command
SELECT NUMBER FROM INVTABLE WHERE &strSel

When I put the pStartNo = "SHA/AI/004/03/2007", pEndNo="SHA/AI/013/03/2007"

It gives us the result contain "SHA/AI/010/04/2006" . Why ?
it seems the above number should not between the rang ???
Next
Reply
Map
View

Click here to load this message in the networking platform