Skip to content

DF_DATABASE_USE_IDENTITY_TYPE

Indicates if the identity type must be used for the recnum column when creating a recnum table.

Level

Database

Supported by

ODBC only, revision 5 and higher

Type

Boolean, temporary

Access

Read/Write

Values

  • True
  • False

Syntax

Use cli.pkg
Get_Attribute DF_DATABASE_USE_IDENTITY_TYPE of {driverNumber} {databaseHandle} to {BooleanVariable}
Set_Attribute DF_DATABASE_USE_IDENTITY_TYPE of {driverNumber} {databaseHandle} to {True|False}

Driver Configuration Keyword

Use_Identity_Type

Remarks

Indicates if the identity type must be used for the recnum column when creating a recnum table. The identity type is the type that has the auto increment attribute set to true and its ID to SQL_INTEGER. If such a type does not exist, it is the first type that has its auto increment attribute set to true.

Example

Procedure ShowDBAttribute Integer iDriver Handle hDatabase
    Boolean bAttribValue
    Get_Attribute DF_DATABASE_USE_IDENTITY_TYPE of iDriver hDatabase to bAttribValue
    Showln "Use identity type: " (If(bAttribValue, "YES", "NO"))
End_Procedure

The sample code above shows the current setting for a given database. The database handle can be obtained via the DF_DATABASE_ID attribute.