I have a TOraclewwDataset Component with the following SQL:

SELECT MASTNAME.*,MASTNAME.ROWID FROM MASTNAME
WHERE NAMEFLD >= :LN

When I use QBE, it is necessary to reset the variable :LN to something like "!" so that the QBE can be properly executed. What happens is this:

Say the first Query sets LN = 'AARON'
Then, by QBE the user wants to search for Last NAME (LN) = 'JONES', all is OK...

But if the first Query sets LN to 'JONES', and the user subsewuently wishes to search for Last Name (LN) = 'AARON', the query fails, because even though the QBE is executing, the PREVIOUS value of LN ('JONES') still has control of the query, and no results are shown.

Any suggestions?
Dave