Home » Developer & Programmer » Forms » Enter Query, remembering the query ran
Enter Query, remembering the query ran [message #80458] Tue, 24 September 2002 08:29 Go to next message
Andrew
Messages: 144
Registered: March 1999
Senior Member
I have 2 forms, lets say ALL_PEOPLE and PEOPLE. The ALL_PEOPLE shows users a list of some details about people in the database. They can use Enter Query mode to put in some values to search on, say only people with the first name of 'Anne'. Then by doubleclicking on the name, they can get to the PEOPLE form, which shows many details they can edit about the person.

The problem is, when they exit the PEOPLE form, and go back to the ALL_PEOPLE form, it doesn't remember the query they entered, and it shows all people in the database. Is there a way to get the form to remember the last query ran, and only show those results?

Thanks in advance for your help.

-Andrew
Re: Enter Query, remembering the query ran [message #80460 is a reply to message #80458] Tue, 24 September 2002 10:09 Go to previous message
ram kumar
Messages: 113
Registered: August 2002
Senior Member
hi
check out
:system.last_query that solves u'r problems..
ram
Previous Topic: Re: Dynamic SQL(Thanks Sameer)
Next Topic: Getting a block's rowid
Goto Forum:
  


Current Time: Sat Mar 02 11:57:43 CST 2024