Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL filters
Message
From
14/12/2005 17:49:21
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL filters
Miscellaneous
Thread ID:
01078076
Message ID:
01078076
Views:
62
If I set a filter as in:

set filter to loc_id = 'A-21'
browse

the result will correctly show one record.
But if I issue:

set exact on
set filter to loc_id = 'A-21'
filterstr = filter()
select * where &filterstr

the result returns A-21, A-219, A-216, A-213 etc. Which is not what we want.

This can be overcome by setting the initial filter as:
set filter to loc_id == 'A-21'

but this construct is difficult in my situation. Is there another solution?

Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform