Walter Meester
HoogkarspelPays-Bas
Jerry,
Seems you want to have a static SQL statment that produces different results caused by the parameters.
One method is to construct the WHERE clause dynamicly.
cWhere= somewhere expression
SELECT * FROM mytable WHERE &cWhere
In local views you can use SELECT * FROM mytable WHERE &?cWhere, but be sure the cWhere variable is available whenever using REQUERY.
Regards,
Walter,
>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,
Précédent
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