GET_SQL_CONSTRAINT¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command returns the current SQL constraint for the given table. If there is no current constraint, then a blank string is returned.

Syntax

GET_SQL_CONSTRAINT of {File} to {variable}

Parameter	Description
File	Name or number of the file
variable	The string containing the constraining SQL expression

Example

Open Customer

String sCon

SET_SQL_CONSTRAINT of Customer to (SFormat('AND "%1"."%2" = ' + "'%3'", "Customer", "Status", "Active"))
GET_SQL_CONSTRAINT of Customer to sCon

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

SQL_CONSTRAINT
SET_SQL_CONSTRAINT