Hi Gregory --

If you can't use parameterized views and you have that many user parms, then you may very well have to build up the "SELECT" statement in code and use SQLEXEC. Which is really not a bad thing.



>I am in the process of converting a VFP application from using local tables to using an Oracle database. The application currently allows the user to query the data by filling in any combination of fields. Presently, the program creates the SQL statement and display a grid to the user where they can then highlight a row a press a zoom button that displays a data entry screen with the selected row.
>
>My question is, how do I handle this when querying a Oracle database. Since the user can choose any combination of say 20 fields, using a parameterized view seems out of the question. I assume that I will need to use SQLEXEC statements. Also, allowing the user this capability, the query could result in 1 to 1000's of rows returned. Is this the correct approach, or is there a better way.
>
>Any Input would be greatly appreciated,
>
>Thanks,
>
>Greg