Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Is this possible?..I sure hope so!
Hello everyone --
My question revolves around the creation of an sql select statement. Can I set a variable on the left hand side of the = sign on a WHERE statement?
I have been able to set the name of a known table and field = to a variable.
Example:
Where voters.state = ?lnparentID
This I have done. I have been able to set the variable equal to a specific table and field and requery the pview to make such a statement work.
However, Let's say I don't know value of what is located in the fieldname I am interested in until run-time. In this case, can I set a variable for the table.fieldname in my WHERE statement?
To sum up> Can I set a variable on the left hand side of the equal sign in my WHERE statement to look at the value for a specific table.fieldname, which is not known until run-time?
Very curious!
TIA for any insight into this question
Jason
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