f2s_column_override_value¶
Applies to: Oracle, MS SQL, MySql, MariaDB, PostgreSQL Drivers
Syntax
set_attribute f2s_column_override_value of {FileNumber} {FieldNumber} to {variable}
get_attribute f2s_column_override_value of {FileNumber} {FieldNumber} to {variable}
Parameter |
Description |
|---|---|
FileNumber |
Number of the file (filename.File_Number) |
FieldNumber |
Number of the column (based on order in FD file) |
variable |
Variant Value. Contains the value that will be used as a default or find constraint. |
Description
This attribute is somewhat like a default in that the value will be used during record creation if a value is not given for the specified column. Unlike a default, this value is also used alongside the f2s_table_override_state attribute to constrain find operations as well. This gives an easy way for an application to be converted to a multi-company setup without requiring extensive code changes (as these settings are global unlike DD defaults for instance).
Note
If f2s_table_constraint is used on the table, then it overrides the f2s_table_override_state and f2s_column_override_value’s won’t be used for find operations. You must remember to manually add your constraints if they apply. This gives a way to bypass this attribute.
Examples
get_attribute
<EXAMPLE>
set_attribute
<EXAMPLE>
Related Attributes
reference
reference 2
ESQL Equivalents
Replaces: <SOMETHING>