Turns the output of cross-reference information on or off during parsing and compiling. Syntax SET XREF ON|OFF Comments The XREF option is set OFF by default. When XREF is ON, the software sends dependency information to the current output when an application program is parsed or compiled. One line of output is generated for every…
Leia mais
Adds a single record to EntitySets or relationships ( ISQL option only). Syntax INSERT INTO object [( field)] VALUES(expr1 | NULL) [EVALUATE clause] [clause] Parameters object The name of an EntitySet or relationship with fields to which you want to add a record. A role name can be used. field A target field in object.…
Leia mais
Lists selected data from the database. Syntax SELECT [ALL] [DISTINCT] values FROM SQLsetspec [-> setname] Parameters ALL An optional keyword indicating that all records of the specified type are to be listed. But, even if ALL is omitted, all records are processed by default. DISTINCT Specifies that only the records that contain unique values in…
Leia mais
Resets most global application settings to their default state. Syntax SET RESET Comments The SET RESET command returns most global application settings to their default values. The global application settings reset to their defaults by SET RESET include SET AUTORETRY NOT APPLICABLE SET CHECKNULLS SET COLUMNSPACING SET CURSOR SET DELIMITER SET DOCLINELENGTH SET EOFVALUE SET…
Leia mais
Run the methods of an ActiveX object. Syntax $ObjRun[Method] (Object, MethodName, «Parameters») Parameters Object an object variable or formfield of type OLE MethodName a string or an expression that evaluates to a string Parameters one or more optional arguments as per the specifications of the object Return Value Returns a result as per the specification…
Leia mais
Ends execution of an application program and returns to the “previous” command level. Syntax RETURN [TO procedure] Parameters procedure The name of a procedure. Must be an ancestor (i.e., the “parent”, “grandparent”, “great-grandparent”, etc.) of the current procedure. Comments The RETURN command stops execution of the current procedure. If a TO clause is omitted, execution…
Leia mais
Replaces segments of a character string with new text. Syntax $translate(source,pattern,replace) Parameters source a character string, or an expression that evaluates to a character string pattern a character string, or an expression that evaluates to a character string replace a character string, or an expression that evaluates to a character string Return Value Character string,…
Leia mais
Performs a Boolean AND of two logic expressions. Syntax expression1 AND expression2 Parameters expression1 A logical expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses. expression2 A logical expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses. Return Value…
Leia mais
Establishes the format for data output. Syntax SET OUTPUT FORMAT [ NORMAL | COMMADELIMITED | XML | XMLSIMPLE | JSON | JSONSIMPLE ] Comments The value of OUTPUT FORMAT is NORMAL by default. That is, the LIST and OUTPUT commands create output whose format exactly follows the Object Dictionary definitions of the individual fields being…
Leia mais
Invokes and interacts with DDE services Syntax $DDEFunction ( p1, p2, p3, p4, … ) Parameters p1 return type, longint p2 command, longint p3 server handle, longint p4 application command, string Comments Where p1, p2, and so on, indicate the desired DDE service and the data required by that service. The first parameter, p1, is…
Leia mais
Portuguese 
English