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

This is the way that QBE works, it limits the result set of the original query. You must either change the original query and remove the where clause, or change the query variable values like you have already done.

If the original query had not been a range query, you could have used QBE instead of a hard-coded where clause.

------------------
Marco Kalter
Allround Automations