Skip to content

DF_DATABASE_DEFAULT_DEFAULT_TEXT

Sets up the default value that will be used when a text column is created.

Level

Database

Supported by

The DataFlex SQL Drivers (SQL Server, DB2, and ODBC), revision 5 and higher.

Type

String, temporary

Access

Read/Write

Values

Any valid default value for a text column.

Syntax

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

Driver Configuration Keyword

Default_Default_Text

Remarks

Sets up the default value that will be used when a text column is created. Columns can be created during conversion or within a restructure operation.

Procedure ShowDBAttribute Integer iDriver Handle hDatabase
    String sAttribValue
    Get_Attribute DF_DATABASE_DEFAULT_DEFAULT_TEXT of iDriver hDatabase to sAttribValue
    Showln "Default Text: " sAttribValue
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.