Helen,

I've never heard about controlling transactions manually when
populating a ClientDataset. I have no idea how to do it. :) dbExpress
always handled this for me.

What should I do?

--
Erick Sasse


2007/10/23, Helen Borrie <helebor@...>:

> At 10:00 PM 23/10/2007, you wrote:
> >Helen,
> >
> >I'm using Delphi with dbExpress and ClientDatasets in a 3-tier app.
> >My transaction configuration is:
> >
> >CommitRetain=False
> >Interbase TransIsolation=ReadCommited
> >
> >dbExpress should handle transactions automatically and I never worried about it.
> >
> >What do you mean by "some abandoned ClientDataset"? My app is 3-tier,
> >so the ClientDataset is completely disconnected. My app server is
> >stateless. The db connection is not owned by any client.
>
> The provider has to be within the context of connection and transaction, though. Do you call Commit on the provider's transaction after populating your ClientDataset?
>
> ./heLen
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>