:system.last_query problem (forms 5)

I 'm having problems with the :system.last_query variable....

The first time a search is made in the form, the WHERE clause of the :system.last_query is OK.

Still, when a second search is made, the new WHERE clause shows the new search criterias AND the search criterias used in the last search.

Example:

Search 1:

SELECT NAME, LAST_NAME FROM TABLEX WHERE USER_ID = 100 AND POSTAL_CODE =
'G1L4C7'

SELECT NAME, LAST_NAME FROM TABLEX WHERE USER_ID = 100 AND POSTAL_CODE =
'G1L4C7' and USER_ID = 666

Have any1 had such a problem ?? Received on Fri Aug 10 2001 - 16:37:31 CEST