FB Generator ID with Applied Updates

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
FredS
Posts: 272
Joined: Mon 10 Nov 2014 17:52

FB Generator ID with Applied Updates

Post by FredS » Fri 28 Nov 2014 21:00

This just showed up on a table with a Generator Name set and on gmPost set.
All works if I don't set the table to use Applied Updates.

Once I do that and want to retrieve an ID before Applying Updates I get ZERO.
Fair enough, I then GET the Next ID via SQL and post, all looks good until I hit Apply Updates then the ID is incremented by the TUniTable component.

Perhaps that function should check for NULL or Zero before generating a new ID?

Its an easy fix to only use self generated IDs but..

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: FB Generator ID with Applied Updates

Post by ViktorV » Mon 01 Dec 2014 09:12

Unfortunately, we could not reproduce the issue in the way you have described.
Please send a small sample to demonstrate the issue to viktorv*devart*com, including a script to create and fill in test database tables.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: FB Generator ID with Applied Updates

Post by ViktorV » Wed 10 Dec 2014 08:34

Thank you for the information. We have reproduced and fixed the issue. The fix will be included in the next UniDAC build.

Post Reply