I have a table with these fields; cdesc, nprice.
I can SELECT * FROM mytable WHERE cdesc = "". This will produce a cursor with all records in the results, which is what I want.
How can I do the same for the numeric field?
SELECT * FROM mytable WHERE cdesc = "" AND nprice = 0 only brings up the records with 0 in nprice. I want all the records. Then I want the user to narrow the search like this;
SELECT * FROM mytable WHERE cdesc = cvar AND nprice = nvar
How can I do this?
Thanks,
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