lcFilter = myfilters.filters select * from mycursor where myfield &lcFilter 9>I need help, please!
>create cursor myfilters (filters c(1)) >insert into myfilters values ('>') >insert into myfilters values ('#') >insert into myfilters values ('=') >insert into myfilters values ('<')>Now, I want to run a query that use with the cursor values for filter as following:
select myfilters >scan > select * from mycursor where myfield <<myfilters.filters>>9 >endscan>
select * from mycursor where myfield>9 >select * from mycursor where myfield#9 >select * from mycursor where myfield=9 >select * from mycursor where myfield<9 >>