I have a local view without parameters. It just shows the user a list of patients to be selected from. It has no Where clause. The patient clicks on a name in the list and they get the patient's record. I use filters to allow the user to search by specific fields.
I want to incorporate an ad hoc Search function which will also populate this cursor. The user wll create the SQL statements for the query, and the results will populate the list of patients. There will be a Where clause. For example, the user might request a list of all patients who are female.
I want to be able to programatically modify the original view so that I can swap in Where statements one after the other, without getting prompted to save because the program has noticed the view has changed.
It seems the best way to do this is to temporarily modify the SQL statement that the cursor is based on (as opposed to say, deleting and appending to the list of patients from a separate Search cursor).
This will allow a requery from the toolbar to propery refresh the view, regardless of the Where clause.
Is there an appropriate 'Codebook' way of doing this?
©2001 Paul Wilford |
