Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Filtering by cursor value
Message
De
24/04/2006 07:29:41
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Filtering by cursor value
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01115918
Message ID:
01115918
Vues:
46
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform