ReconcileError dialog, again

Pekka Haara

unread,

Feb 27, 1998, 3:00:00 AM2/27/98

to

I have problems when I use the ReconcileError dialog of Delphi. The
conflicting
values (if i change database values between read/write operations of
CDS) of CDS doesn't update
a database when I use Correct option. If there is no conflicting values
in the CDS everything works fine.
What might be wrong?

Should there be a original value field visible in reconcileerror dialog?

A show conflicting fields only -checkbox is also grayed. In what
situations these features are
available? Should there be more options available than skip, cancel and
correct? I don't have.

My program settings: Delphi 3.02 C/S, BDE 4.51, SQL Server 6.5

I also tried a demo program (in below ) which Josh sent. It didn't work
also.

>
> 1. New Application
> 2. Add Reconcile Error Dialog
> 3. Drop TTable hook it up to COUNTRY.DB in DBDEMOS
> 4. Drop TClientDataSet, TDataSource, TDBGrid and hook
them up.
> 5. FormCreate...
> ClientDataSet1.Provider := Table1.Provider;
> ClientDataSet1.Open;
> 6. FormCloseQuery...
> CanClose := ClientDataSet1.ApplyUpdates(-1) = 0;
> 7. ClientDataSet1ReconcileError...
> Action := HandleReconcileError(DataSet, UpdateKind,
E);
> 8. Run
> 9. Change a field value.
> 10. Change the same value in SQL Explorer.
> 11. Close application.

/Pekka

Josh Dahlby

unread,

Feb 27, 1998, 3:00:00 AM2/27/98

to

>I have problems when I use the ReconcileError dialog of Delphi. The
>conflicting
>values (if i change database values between read/write operations of
>CDS) of CDS doesn't update
>a database when I use Correct option. If there is no conflicting values
>in the CDS everything works fine.

Did you call ApplyUpdates again after choosing Correct? After errors are
reconciled it just changes the values in the CDS. In order to have the
values update the DBMS you need to call ApplyUpdates again.

Josh

Pekka Haara

unread,

Mar 2, 1998, 3:00:00 AM3/2/98

to

Josh Dahlby wrote:

> Did you call ApplyUpdates again after choosing Correct? After errors are
> reconciled it just changes the values in the CDS. In order to have the
> values update the DBMS you need to call ApplyUpdates again.
>

Where do I put a ApplyUpdates command? A demo program which yousent have this
command in a formclosequery event.

>CanClose := ClientDataSet1.ApplyUpdates(-1) = 0;

Do I need another ApplyUpdates command elsewhere? If i try to close the
program
multiple times and choose always Correct the program never close. If I choose

cancel the program will close nicely.

Does this applyupdates command change the current value of field? If it does
maybe the problem is there because I can't see those current value fields in
the
ReconcileError dialog.

/Pekka

> Josh

Josh Dahlby

unread,

Mar 2, 1998, 3:00:00 AM3/2/98

to

>Does this applyupdates command change the current value of field? If it
does
>maybe the problem is there because I can't see those current value fields
in
>the ReconcileError dialog.

What does it say is conflicting, and when you select Correct, what do you
change? When you say Correct, you need to correct the Modified Values so
that they will work in the next ApplyUpdates.

Josh