Board index » delphi » TSQLClientDataSet always do CommitRetaining for transaction in Master/Detail relation

Chau, Chee Yang

Delphi Developer
Thu, 23 Dec 2004 16:51:19 GMT

TSQLClientDataSet always do CommitRetaining for transaction in Master/Detail relation

Hi,

I have a question here:

I have two TSQLClientDataSet, one master and one detail.  When I scroll the
master dataset, the detail will fetch data from interbase server.  I use
TSQLMonitor to monitor the execution of SQL of server and notice this
behaviour:

16:48:53.830 : INTERBASE - isc_start_transaction
16:48:53.830 : INTERBASE - isc_dsql_execute
16:48:53.830 : INTERBASE - isc_dsql_fetch
16:48:53.830 : INTERBASE - isc_dsql_fetch
16:48:53.830 : INTERBASE - isc_commit_retaining                ------>
Commit Retaining
16:48:53.830 : INTERBASE - isc_dsql_free_statement
16:48:53.840 : INTERBASE - isc_dsql_execute
16:48:53.840 : INTERBASE - isc_dsql_fetch
16:48:53.840 : INTERBASE - isc_dsql_fetch
16:48:53.840 : INTERBASE - isc_commit_retaining
16:48:53.840 : INTERBASE - isc_dsql_free_statement

I don't want to the transaction calls commit retaining and wish the
transaction call commit to end the transaction.  How could I archieve that
with DBExpress?  I can do it with IBX.  Please advice.

Regards,
Chee Yang

 
Bill Tod

Delphi Developer
Thu, 23 Dec 2004 21:38:53 GMT

Re:TSQLClientDataSet always do CommitRetaining for transaction in Master/Detail relation


What is the CommitRetaining parameter of your TSQLConnection component
set to?

On Sun, 7 Jul 2002 16:51:19 +0800, "Chau, Chee Yang" <c...@bce.com.my>
wrote:

Quote
>Hi,

>I have a question here:

>I have two TSQLClientDataSet, one master and one detail.  When I scroll the
>master dataset, the detail will fetch data from interbase server.  I use
>TSQLMonitor to monitor the execution of SQL of server and notice this
>behaviour:

>16:48:53.830 : INTERBASE - isc_start_transaction
>16:48:53.830 : INTERBASE - isc_dsql_execute
>16:48:53.830 : INTERBASE - isc_dsql_fetch
>16:48:53.830 : INTERBASE - isc_dsql_fetch
>16:48:53.830 : INTERBASE - isc_commit_retaining                ------>
>Commit Retaining
>16:48:53.830 : INTERBASE - isc_dsql_free_statement
>16:48:53.840 : INTERBASE - isc_dsql_execute
>16:48:53.840 : INTERBASE - isc_dsql_fetch
>16:48:53.840 : INTERBASE - isc_dsql_fetch
>16:48:53.840 : INTERBASE - isc_commit_retaining
>16:48:53.840 : INTERBASE - isc_dsql_free_statement

>I don't want to the transaction calls commit retaining and wish the
>transaction call commit to end the transaction.  How could I archieve that
>with DBExpress?  I can do it with IBX.  Please advice.

>Regards,
>Chee Yang

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
Chau Chee Yan

Delphi Developer
Wed, 29 Dec 2004 10:20:46 GMT

Re:TSQLClientDataSet always do CommitRetaining for transaction in Master/Detail relation


What is CommitRetaining parameter? Where to set it. I never set it.

--
--
Best Regards,
Chau Chee Yang
BCE Software Sdn. Bhd. ---> www.bce.com.my

Quote
"Bill Todd" <b...@notthis.dbginc.com> wrote in message

news:b2hgiu0lemhc8947s3apjquj47c6l21ucp@4ax.com...
Quote
> What is the CommitRetaining parameter of your TSQLConnection component
> set to?

> On Sun, 7 Jul 2002 16:51:19 +0800, "Chau, Chee Yang" <c...@bce.com.my>
> wrote:

> >Hi,

> >I have a question here:

> >I have two TSQLClientDataSet, one master and one detail.  When I scroll
the
> >master dataset, the detail will fetch data from interbase server.  I use
> >TSQLMonitor to monitor the execution of SQL of server and notice this
> >behaviour:

> >16:48:53.830 : INTERBASE - isc_start_transaction
> >16:48:53.830 : INTERBASE - isc_dsql_execute
> >16:48:53.830 : INTERBASE - isc_dsql_fetch
> >16:48:53.830 : INTERBASE - isc_dsql_fetch
> >16:48:53.830 : INTERBASE - isc_commit_retaining                ------>
> >Commit Retaining
> >16:48:53.830 : INTERBASE - isc_dsql_free_statement
> >16:48:53.840 : INTERBASE - isc_dsql_execute
> >16:48:53.840 : INTERBASE - isc_dsql_fetch
> >16:48:53.840 : INTERBASE - isc_dsql_fetch
> >16:48:53.840 : INTERBASE - isc_commit_retaining
> >16:48:53.840 : INTERBASE - isc_dsql_free_statement

> >I don't want to the transaction calls commit retaining and wish the
> >transaction call commit to end the transaction.  How could I archieve
that
> >with DBExpress?  I can do it with IBX.  Please advice.

> >Regards,
> >Chee Yang

> --
> Bill (TeamB)
> (TeamB cannot respond to questions received via email)

Bill Tod

Delphi Developer
Wed, 29 Dec 2004 21:19:53 GMT

Re:TSQLClientDataSet always do CommitRetaining for transaction in Master/Detail relation


Use the Object Inspector to view the Params property of your
TSQLConnection component.

On Sat, 13 Jul 2002 10:20:46 +0800, "Chau Chee Yang"

Quote
<cha...@bce.com.my> wrote:
>What is CommitRetaining parameter? Where to set it. I never set it.

>--

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Other Threads

1. Master detail rel.

2. TSQLClientDataSet: setting Master/Detail ID fields incorrectly...

3. Master-Detail Query w/Cached Updates requeries Detail when updating single fields in Master

4. Master/Detail w/SQL Server shows all detail records when inserting a new master record

5. Problem: Master/Detail shows details during Master Insert

6. Questions with indexes and master-rel.

7. Transaction with Master/Detail and ADO

8. Master\Detail Transaction

9. Sybase - Master/detail records and Transactions

10. Master detail form and transaction problems