I'm getting this error (9729) what is supposed to raise when you're trying to post a
duplicate keyvalue in an index.

However, the index in cuestion, is only one Autoinc field, so, i'm not assigning any
values to it.

This is what i'm doing: (Remote session)

1.  Filter the Table.
2.  BeginCachedUpdates; (To improve speed)
3.  Append and Edit the dataset.
4.  BeginTrasaction;   ApplyCachedUpdates;
5.  Getting a nasty exception. (ErrorCode 9729 saying that my primary key is duplicated)
6.  Rollback the transaction in the Except clause of the try statment.

The most extrange thing is, if i call applyupdates a secondtime, the updates are posted
with no exceptions.


Any ideas of what i'm doing wrong? maybe a bug with the cachedupdates?

I tried to set the OnCachedUpdatesError, and the OnPostError but they get never called.


 

David,

step 1 has to be eliminated. When you test for duplicates in filtered table
you might not find the existent key if the key of imported record does not
fit in filter. Insert procedure on the other side checks entire table and
there is a reason for finding record with existent key.

I have no idea why repeated action does not raise the same exception.

Iztok Lajovic

> This is what i'm doing: (Remote session)
>
> 1.  Filter the Table.
> 2.  BeginCachedUpdates; (To improve speed)
> 3.  Append and Edit the dataset.
> 4.  BeginTrasaction;   ApplyCachedUpdates;
> 5.  Getting a nasty exception. (ErrorCode 9729 saying that my primary key
> is duplicated)
> 6.  Rollback the transaction in the Except clause of the try statment.
>
> The most extrange thing is, if i call applyupdates a secondtime, the
> updates are posted
> with no exceptions.
>
>
> Any ideas of what i'm doing wrong? maybe a bug with the cachedupdates?
>
> I tried to set the OnCachedUpdatesError, and the OnPostError but they get
> never called.
>
>
>
>

David,

<< I'm getting this error (9729) what is supposed to raise when you're
trying to post a duplicate keyvalue in an index.

However, the index in cuestion, is only one Autoinc field, so, i'm not
assigning any values to it.

This is what i'm doing: (Remote session)

1.  Filter the Table.
2.  BeginCachedUpdates; (To improve speed)
3.  Append and Edit the dataset.
4.  BeginTrasaction;   ApplyCachedUpdates;
5.  Getting a nasty exception. (ErrorCode 9729 saying that my primary key is
duplicated)
6.  Rollback the transaction in the Except clause of the try statment.

The most extrange thing is, if i call applyupdates a secondtime, the
updates are posted with no exceptions. >>

You currently can't use autoinc columns with cached updates.  The cached
updates process causes the autoinc columns to be assigned values, and that
is what causes the duplicate key exception.  I'll put this on the list of
items to be addressed in the next build.

--
Tim Young
Elevate Software
www.elevatesoft.com