Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 3 of 3 total |
DBISAM_KEYVIOL (9729) |
Tue, Aug 28 2007 3:40 AM | Permanent Link |
David Cardenas | 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. |
Tue, Aug 28 2007 5:31 AM | Permanent Link |
"Iztok Lajovic" | 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. > > > > |
Tue, Aug 28 2007 7:31 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |