>I am presently using SQL pass through due to the large number of orders that are possible. The following code works for small tables all the time but on the primary table that is approx. 100,000 rows returns an error sometimes. Is there a better way to provide this functionality?

Greg,

What's the error? I'm not familiar with Oracle but maybe there's a way to control the max. rows on the server side w/o going through ODBC.

-Mike