Helen, as always - Thanks for your timely post.

As you can probably tell, I am using the primary key in my master table to identify records in a detail table. I am getting the anticipated value of the new master record before it is committed in case the user decides not to commit. If the user commits, it all goes great unless another user happens to sneak in. This will not likely be the case in this database (famous last words). I would, however, prefer to do it the right way, but not sure how to approach it. Any suggestions on avoiding mismatches?

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 09:54 AM 13/04/2012, Craig Cox wrote:
> >(Firebird 1.5+, Delphi XE, IBOjects)
> >
> >I'm guessing there is a very simple answer to this problem.
> >
> >I want to get the current generator value of one table
>
> Tables don't have generators. A generator is a self-contained sequence. You'll need to know the name of the generator that is used to populate the column in question, then you can use GeneratorValue(Name_of_Generator, 0) to get the latest value that has been generated.
>
> >, increment it in Delphi and use the new value in another table. I thought the GeneratorValue() method looked promising, but I may not understand it well enough to use it properly. If you can tell me how to get the value of the generator, I think I can figure out the rest.
>
> Sounds dicey, unless your database has only one user.
>
> Helen
>