SQL Server Cursor location with Delphi DBGrid

Thread77 · #1 (**permalink**) 04-16-03, 16:59

Hello,

I am working on an interface to an SQL Server 7 database. The tables in this database are extremely large and using a Client side cursor on the tables is too slow. I would like to use a server side cursor instead, but the program uses DBGrids thoughout and the delphi DBGrids complain that bookmarking is not available for the server side cursor. Does anyone know of a way around this, or of a DBGrid alternative that would not have this problem? Thanks!
richard

moz · #2 (**permalink**) 04-21-04, 20:27

Quote:

Originally posted by Thread77
Hello,

I am working on an interface to an SQL Server 7 database. The tables in this database are extremely large and using a Client side cursor on the tables is too slow. I would like to use a server side cursor instead, but the program uses DBGrids thoughout and the delphi DBGrids complain that bookmarking is not available for the server side cursor. Does anyone know of a way around this, or of a DBGrid alternative that would not have this problem? Thanks!
richard

Internet Services

Web Development

Digital Marketing

Consumer Tech