Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
TADCustomConnection.GetLastAutoGenValue Method
TADCustomConnection Class  TADCustomConnection Members  uADCompClient Namespace  Example  public  See Also  Send Feedback

Returns last auto generated value.

Group

public

Links
TADCustomConnection Class, TADCustomConnection Members, uADCompClient Namespace, Example, public, See Also
Parameters
Parameters 
Description 
const AName: String 
The name of generator or sequence or empty string. 
Returns

The last auto generated value

Description

The GetLastAutoGenValue method returns last auto-generated value. The meaning and result depends on DBMS:

DBMS 
Description 
Oracle 
AName is the name of a sequence. The method will return CurrValue, if it exists in the session. 
Interbase / Firebird 
AName is the name of a generator. The method will return GEN_ID(0). 
MS SQL Server, MySQL, etc 
The last auto generated value in the session. 
Syntax
function GetLastAutoGenValue(const AName: String): Variant;
See Also
Example
ShowMessage(VarToStr(ADConnection1.GetLastAutoGenValue('MyGen')));
What do you think about this topic? Send feedback!