There has to be a way since VFP does it for the views but it probably involves some obscure work with the ODBC API, perhaps from an FLL or some such. Oh well, if this stuff was easy...

On another note, I lived in Atlanta for 8 years. Spring up here means watching for the lakes to melt. I saw fish houses on a nearby lake just a couple of weeks ago.

Gary

>>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.