Erases an object from an application directory. Syntax #1 Erases an object from an application directory. ERASE object name [FROM dirname] [KEEP] Parameters object One ofconstant, directory, display, document, EntitySet, form, menu, relationship, role, set, variable, window name The name of the object. dirname The name of the application directory from which object is erased.…
Read more
Establishes a connection to Zim Integrated Server or an SQL database. Syntax connect to [ “ZIMSERV” | “JDBCSAM” | alias name ] using (database name, SQL server name, userid, password, server name, domain name) alias name is or as defined in the configuration file “zimalias.zim”. database name is the logical database name is either the…
Read more
Instructs SQL commands to be generated with the FOR UPDATE OF option. Syntax SET FOR UPDATE ON|OFF Comments When connected to any SQL servers, the SQL syntax generated to perform operations on the remote server can be controlled to add the FOR UPDATE OF option on the primary key fields to SELECT commands. The option…
Read more
Branches to another location in an application program. Syntax GOTO labelname Parameters labelname An identifier that has been declared as a label in the procedure executing the GOTO command. Comments GOTO can be used only to branch forward or backward within the same procedure. To declare a label, type the labelname, followed by a colon,…
Read more
Presents a message box to the application user and waits for a response. Syntax $messagebox(message,type,style,defaultbutton[,heading]) Parameters message A character string, or an expression that evaluates to a character string. type A number that determines the type of message box. It also determines the icon that appears in the message box. style A number that determines the…
Read more
Presents the application user with a File Open common dialog box. Syntax $filebrowse(directorypath, pattern, flags ,[heading]) Parameters directorypath A character string or an expression that evaluates to a character string, naming the default directory path to show in the dialog box. If path is the null string (”), the current directory is used as the…
Read more
Identifies particular records in an SQL database. Syntax Object [WHERE clause] [GROUP BY expr1] [HAVING expr2] [ORDER BY expr3 [ASC|DESC]] [KEEP component] Parameters object The name of an EntitySet, relationship, form, structured application document, or result set. Role names can be used for EntitySets and relationships. expr1 A value expression. Specifies how the selected records…
Read more
SET (EntitySet/Data Relationship Attribute) Modifies the value of an attribute of a database object. Syntax SET tablename tabletype [ “ZIMSERV” | “JDBCSAM” | alias name ] SET tablename [ remname | remowner ] value SET fieldname [ remname ] value tablename is the name of an EntitySet or data relationship fieldname is the name of…
Read more
Selects data for a report and specifies overall report format. Syntax REPORT [num] FROM [setspec] [GRAPHIC [TEMPLATE name]] [orientation] [PAUSE n] [format options] [-> clause] Parameters num Places a limit on the number of records from setspec used in the report. Num can be an integer constant (e.g., 15, 200), a variable, form field, menu…
Read more
Dynamically modifies appearance and behavior attributes of open forms or form fields in the current window. Syntax #1 Dynamically changes certain attributes of open forms, form fields, or displays. FORM SET («option») «object» Parameters option Can be [NOT] ABBREVIATE, [NOT] AUTOCLEAR, [NOT] AUTOSKIP, [UN] AVAILABLE, [NOT] BOLD, [NOT] CLICK, [NOT] DOUBLECLICK, EVENT eventName, FILLCOLOR color,…
Read more
English 
Portuguese