DF_DATABASE_DUPREC_STATE

The SQL status code for the back-end’s duplicate records error.

Level

Database

Supported by

DataFlex ODBC Driver, revision 5 and higher

Type

String, temporary

Access

Read/Write

Values

SQL status code

Syntax

Use cli.pkg
Get_Attribute DF_DATABASE_DUPREC_STATE of {driverNumber} {databaseHandle} to {StringVariable}
Set_Attribute DF_DATABASE_DUPREC_STATE of {driverNumber} {databaseHandle} to {StringVariable}

Driver Configuration Keyword

Duprec_State

Remarks

The SQL status code for the back-end’s duplicate records error. When this error occurs, the driver will translate it to the DataFlex duplicate record error number (DFERR__DUPLICATE_REC, error 28 "Duplicate records not allowed").

Example

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

Procedure ShowDBAttribute Integer iDriver Handle hDatabase
    String sAttribValue
    Get_Attribute DF_DATABASE_DUPREC_STATE of iDriver hDatabase to sAttribValue
    Showln "Duplicate records error SQL State: " sAttribValue
End_Procedure