Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
how can I make a field that I want pick in sql statement generic. For example I can write the following sql statements
select firstname from testdata into cursor test where firstname == a
select lastname from testdata into cursor test where lastname == b
select address from testdata into cursor test where address == c
how can I make it so that the selection fields can substituted with a variable? for example
select fieldname from testdata into cursor test where fieldname == somevariable
I want to be able to choose my own fieldnames.
Thanks
Nick Patel
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement