Doug,
You could use a parameterized view.
>I am working on a prototype VFP 6.0 front end to an Oracle 8i database, and I have one requirement view that selects data from 5 tables that will populate a form. When a view is created the SQL is generated by the query builder, and by default it is viewable as read-only, and retrieves all records.
>This is not a good thing as relates to netwark travffic, when all I want is to execute the query and search for one record,
>
>What I want to do is to open the form with noDataOnLoad and do a search on a key field, assign that to a variable and have the variable in the WHERE clause of the SQL statement to retrieve a single record for updating. Next it would populate the form with the fields from that one record in the view. I probably have already done the code, programmically, but I would like to hear some of your ideas as to best practices.
Daniel