General information
Title:
SQL Problem - what wrong with this code?
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only