>Hi George,
>I think we may be talking at crossed purposes here. What I'm trying to do is emulate the functionality in the "Records to fetch at a time" and the "Maximum records to fetch" spinners in the Tool/Options/Remote data tab. I want to be able to limit the number of records that a user can bring down off the back end from a SQL pass through query created at run time. We have some multi million row tables that a user could possibly bring across and that would be a Bad Thing. If I were using remote views, I could set them with dbsetprop(). I'm looking for a way to limit it for SQL pass through. Thanks.
>
Gary,

The options shown there apply strictly, AFAIK, to remote views and not SPT.