Using a SETROWCOUNT & dbGridInc

[Chris Turner]

We are trying to restrict the # of records that are returned in our queries using both SET ROWCOUNT in T-SQL and dbGridInc in ASPdb.

We have just moved to a new configuration, and now this doesn't seem to work. Any suggestions?

We are using ASPdb Ver. 1.2506 Pro, MS SQL Server 7.0 on a Win2K server.

[Mark]

Chris,
Are you saying it worked with the old configuration?
Just set dbGridInc=50 (or whatever you want).
How many records do you want? What does your source code look like?
Mark.


------------
Chris Turner at 4/24/00 4:20:40 PM


We are trying to restrict the # of records that are returned in our queries using both SET ROWCOUNT in T-SQL and dbGridInc in ASPdb.

We have just moved to a new configuration, and now this doesn't seem to work. Any suggestions?

We are using ASPdb Ver. 1.2506 Pro, MS SQL Server 7.0 on a Win2K server.