At 03:36 PM 7/04/2005 +0200, Mr Bamsemums wrote:

>So, probably the best for small resultsets would be to use the
>TClientDataset
>(or similar) component and have the server commit the SELECT ASAP.

Hmm, thereby hangs a whole big sectarian debate in the various Delphi
interface camps about the benefits (or otherwise) of marooning data that
the user is working on from current database state. It's not a thread to
get started on here, since this isn't a Delphi forum.

./hb