Dennis
> Also, if you use dbgrids and client side cursors, it keeps record locks on
> SQL server until the user scrolls to the end of the recordset. This can
> then cause problems on other machines needing to write to the locked
> records. I have found that you should either keep the recordsets small
and
> scroll to the end, or else, use a snapshot recordset (eg. on a temporary
> table).
Can you clarify this, ie client side cursor using what mechanism?
If it was an ADO client side static then this couldn't be the case,
generally
the rule is don't use cursors (as provided be the server) The thing is that
client side cursors aren't really cursors
Neven
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
