Deletes data from EntitySets or relationships with fields. Syntax DELETE [num] [setspec] [EVALUATE clause] [-> clause] Parameters num Can be an integer constant (15, 200); a variable, a form field, or a parameter that evaluates to an integer; the word ALL. If num is omitted, or less than 0, it defaults to 1. setspec The…
Read more
Deletes records from EntitySets or relationships with fields. Syntax DELETE [ALL] FROM SQLsetspec [EVALUATE clause] [-> clause] Parameters ALL Optional. Whether or not you include the ALL argument, all records in SQLsetspec are deleted. SQLsetspec An SQL set specification. If omitted, records are deleted from the current set (if it exists). Comments DELETE FROM is…
Read more
Returns information about the currently accessed application directories. Syntax $dirpath() Return Value Character string. Comments $dirpath returns a character string consisting of the names of all currently accessed application directories and their access types (U for update, R for read). Information about each directory is enclosed in semicolons (;). The directory name appears first, followed…
Read more
Encrypts the data in an EntitySet or relationship with fields. Syntax ENCRYPT object Parameters object The name of an EntitySet or a relationship with fields. Can be a role name. Comments The ENCRYPT command makes stored data meaningless to anyone scanning a raw database file on disk, thereby protecting the data from unauthorized access. The…
Read more
Changes the runtime file name of a connector document Syntax SET CONNECTOR DOCUMENT connector document TO filename Parameters connector document The name of the connector document. filename The file name to which the connector document will be referencing. Comments The SET CONNECTOR DOCUMENT changes the run-time value for the filename field on a connector document.…
Read more
Specifies if quotation marks are required for character strings. Syntax SET QUOTING ON|OFF Comments The QUOTING option is set OFF by default. Setting QUOTING ON causes the software to issue a warning message each time it encounters a non-numeric character string not enclosed in quotation marks (i.e., unquoted character strings that are valid numbers do…
Read more
Controls the call tracing of procedures. Syntax SET [LOCAL] FLOW ON|OFF Parameters LOCAL The command is to take effect only within the current procedure. Comments Call tracing messages show shifts in execution control from one procedure to another. The SET FLOW command controls call tracing. FLOW is OFF by default. When FLOW is ON, the…
Read more
Calculates a time value by adding minutes to (or subtracting minutes from) a specified time value. Syntax $addminutes(time,number) where time an 8-digit number or an expression that evaluates to an 8-digit number, that expresses a valid time value in the format HHMMSSTT number a number or an expression that evaluates to a number Return Value…
Read more
Indicates the reason that a deadlock condition occurred. Syntax $deadlockreason Return Value A character string. Cannot be reset by an application program. Description $DeadlockReason contains one of the following reason codes for the current deadlock condition: Code Reason 0 transaction completed normally 1 transaction terminated due to time out 2 transaction terminated due to transaction…
Read more
English 
Portuguese