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…
Leia mais
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…
Leia mais
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…
Leia mais
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…
Leia mais
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.…
Leia mais
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…
Leia mais
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…
Leia mais
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…
Leia mais
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…
Leia mais
Portuguese 
English