Saving off forms query criteria

From: Parichai Kalari <pkalari_at_abbnm.com>
Date: Fri, 08 Jun 2001 15:53:40 -0500
Message-ID: <3B213B54.9666E752_at_abbnm.com>


[Quoted] Some of you may have done this, but is there a way we can save query criteria in forms and retrieve them later to re-execute them(like in Access)? Here is an example.

Consider an employee table.

A person can query in the following ways:

  1. Query all employees who are male, age>50, last name starts with S and years of service between 10 and 20.
  2. Query all employees who are female, whose join dates are in the years 1985,1989,1990 and whose dept is like '%AGR%'.
He wants to save the two query criteria above and come back and re-execute them later without re-entering all the criteria. What would be the best approach for this?

Forms 6i is being used.

Any suggestions are appreciated.

Thanks Received on Fri Jun 08 2001 - 22:53:40 CEST

Original text of this message