>Is this something you can place on the server as a stored procedure? Then you could just pass parameters to it.
>
>
>Wayne

The length of the query comes from the user being able to hand pick items from pick lists that are translated into "IN" lists on the WHERE clause. Usually, the items will not translate into a LIKE clause.

The VFP interface to Oracle is supposed to work just like an existing VFP application that gets data from native VFP tables. Based on real world queries with the existing VFP application, I need to be able to pass about 100,000 bytes of SELECT syntax to the Oracle Server.

A co-worker found some info that suggests that different versions of the ODBC drivers have different limits. There's Oracle 7 drivers that have 30K and 64K limits, and Oracle 8 drivers are supposed to not have a limit.

Since upgrading to Oracle 8 is currently out of the question and 64K is not going to allow some queries to work, I will continue to investigate the Stored Procedure option. Do you know what the limits are for passing parameters to a Stored Procedure?

Thanks,
David