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
Title:
SQL Problem - what wrong with this code?
Miscellaneous
Thread ID:
00142064
Message ID:
00142064
Views:
69
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'
Next
Reply
Map
View

Click here to load this message in the networking platform