SQL_CONSTRAINT¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command is used to toggle on or off the current SQL constraint that is set for a table. To deactivate the current constraint, pass the constant DEACTIVATE to this command. to reactivate the constraint, pass ACTIVATE to this command.

Syntax

SQL_CONSTRAINT of {File} to {Activate|Deactivate}

Parameter	Description
File	Name or Number of the file
Activate	Activates the constraint
Deactivate	Deactivates the constraint

Example

Open Customer

SET_SQL_CONSTRAINT of Customer to (SFormat('AND "%1"."%2" = ' + "'%3'", "Customer", "FirstName", "Aaron"))
SQL_CONSTRAINT of Customer to Deactivate

For_All Customer by Index.1 do
    Showln Customer.FirstName
End_For_All

SET_SQL_CONSTRAINT
GET_SQL_CONSTRAINT