f2s_column_default_sql_value¶

Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers

Syntax

set_attribute f2s_column_default_sql_value of {FileNumber} {FieldNumber} to {variable}
get_attribute f2s_column_default_sql_value of {FileNumber} {FieldNumber} to {variable}

Parameter

Description

FileNumber

Number of the file (filename.File_Number)

FieldNumber

Number of the field (field field name)

variable

String variable. The default value for the field.

Description

This attribute is used to get or set the default value for a given column. Getting the default value can be done anywhere in the code, however, setting the value can only be done within a Structure_Start/Structure_End block.

Different databases use different formats for the default values. If the variable is malformed, the default value for the column will be deleted but NOT recreated. No error is generated.

When creating a table, if the attribute is not set, it is defaulted to the driver default. For more information, please see Mertech.cfg.

Examples

get_attribute

Handle hOrderHea
Integer iDate
String sDefault

Move OrderHeader.File_Number to hOrderHea
Field_Map hOrderHea "Order_Date" to iDate
Get_Attribute f2s_column_default_sql_value of hOrderHea iDate to sDefault

set_attribute

Handle hOrderHea
Integer iDate
String sDefault

Move OrderHeader.File_Number to hOrderHea
Field_Map hOrderHea "Order_Date" to iDate

Get_Attribute f2s_column_default_sql_value of hOrderHea iDate to sDefault

Showln (SFormat("The Default value for Date is %1", sDefault))

Structure_Start hOrderHea _f2s_ActiveDriver
//This would NOT work using f2s_column_default_sql_value_legacy
Set_Attribute f2s_column_default_sql_value of hOrderHea iDate to "GetDate()"
Structure_End hOrderHea DF_STRUCTEND_OPT_NONE "." 0

Open OrderHeader
Move OrderHeader.File_Number to hOrderHea
Field_Map hOrderHea "Order_Date" to iDate

Get_Attribute f2s_column_default_sql_value of hOrderHea iDate to sDefault

Showln (SFormat("The Default value for Date is %1", sDefault))

Related Attributes

Replaces: DF_FIELD_DEFAULT_FUNCTION