Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Problem - what wrong with this code?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00142064
Message ID:
00142067
Views:
28
>create table tempX (district c(3))
>
>select tempX
>index on district tag district
>insert into tempX (district) values ('1')
>insert into tempX (district) values ('1A')
>insert into tempX (district) values ('1B')
>insert into tempX (district) values ('1C')
>
>lcInlist = " inlist(alltrim(district), '1','1C')
>select * from tempx where &lcInlist into cursor junk
>
>_tally = 4 && all four records with 'SET EXACT ON' & 'SET NEAR OFF'

SET ANSI ON will give 2. SQL behaviour depends on this setting.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform