Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filtering by cursor value
Message
From
24/04/2006 07:29:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Filtering by cursor value
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01115918
Message ID:
01115918
Views:
45
Hi
I need help, please!

OK
I have a cursor as following:
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
By this scan I want to get the following queries:
select * from mycursor where myfield>9
select * from mycursor where myfield#9
select * from mycursor where myfield=9
select * from mycursor where myfield<9
Thank's
Thank you
Chaim
Next
Reply
Map
View

Click here to load this message in the networking platform