FB Generator ID with Applied Updates
Posted: 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..
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..