f2s_table_override_state¶
Applies to: Oracle, MS SQL, MySql, MariaDB, PostgreSQL Drivers
Syntax
set_attribute f2s_table_override_state of {FileNumber} to {variable}
get_attribute f2s_table_override_state of {FileNumber} to {variable}
Parameter |
Description |
|---|---|
FileNumber |
Number of the file (filename.File_Number) |
variable |
Boolean Variable. True, the f2s_column_override_value` is used, |
Description
This boolean attribute determines if the value in f2s_column_override_value is used as an automatic constraint on the table. When set to true, find operations will have an automatic constraint based on the value for of any f2s_column_override_value’s (there could be multiple columns with override values). This is useful in multi-company setups as it will effectively limit the table to a subset of records. If f2s_table_override_state is false then finds act as they normally do.
Note
If f2s_table_constraint is used on the table, then it overrides the f2s_table_override_state and 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>