Help with fetch size

[dickylam]

I am using SQL database with a table of increasing records.

When I create a sql view with remote connection, I set the dbsetprop of fetch size to -1 (unlimited), I then can see all records in the table

However, if the table is keeping growth, let say total 25,000 records, I still cannot see all records.

What's wrong with this setting ? Anybody knows this

thanks.

 

[Mike Lewis]

Dickylam,

Are you perhaps confusing "records to fetch at a time" with "maximum records to fetch". The first one will give you all the records, but spread over several batches. The second imposes an overall maximum on the number of records.

Also, be aware that SQL Server has its own setting for the maximum records to return, which is independent of the VFP setting. The database administrator might use this to prevent runaway queries from downloading too many records. You use SET ROWCOUNT in T-SQL to vary the setting.

Hope this helps.

Mike
Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk