Read generator field of firebird database.
Posted on 2007-08-08
i am new in firebird and i develop an application in delphi.I want to know if it there is a way from delphi to read from the generators category of a firebird database a field so to be able to know any time what value has and if i want to deleted or to update this value.
For example when we create a table in firebird at the same time if we have an auto increment field it produce a GEN_ID field.Let's say i have a table people and i have to the generators the auto increment field
PEOPLE_ID_GEN.I want to be able to read from delphi the current value of the PEOPLE_ID_GEN and to update or delete this value with sql commands throw delphi.
Thanks in advance!