The {DatabaseQuery} macro sends the specified SQL statement to either ODBC or BDE and places the returned data in the specified block of cells.
Parameters
Type Type of database to query: "Paradox", "ODBC", or "BDE (Borland Database Engine)".
Name Name of the database. If the type is Paradox, the name must be a path. If the type is ODBC, the name is a Data Source Name (DSN) from the user's ODBC configuration. If the name is BDE, the name is an alias name from the user's IDAPI/BDE configuration.
QueryString An SQL Statement.
Destination The destination block of cells where to send the result.
DATE
Syntax
Date()
Description
{DATE} is equivalent to pressing Ctrl+D, which lets users enter a date or time into the active cell.
You can enter a date in a cell without using Ctrl+D. Just type a date in one of Quattro Pro's date formats--for example, 6/1/95.
Example
{DATE}8/6/90~ enters 8/6/90 in the active cell as a date.
{DATE}{?}~ pauses to let the user enter a date, then enters that date into the active cell.
DbAlias
Syntax
DbAlias(type As _DbAlias_type_enum, Path As String)
{DbAlias} lets you specify a private directory to hold temporary files, or a working directory where external data tables are most likely to be found.
Parameters
WORK | PRIV WORK to specify a Working directory; PRIV to specify a Private directory
Path path for the Working directory or the Private directory
{DELETEMENU}
Syntax
DeleteMenu(MenuPath As String)
PerfectScript Syntax
DeleteMenu (MenuPath:String)
Description
{DELETEMENU} removes the menu specified by MenuPath from the menu system. See the description of {ADDMENU} for the syntax of MenuPath. Use {DELETEMENUITEM} to remove an individual menu item.
Example
{DELETEMENU "/File"} removes the File menu from the active menu system.
Parameters
MenuPath Menu in the tree to delete; type a forward slash (/) followed by the menu name; for example, to delete the Edit menu, type /Edit.
Notes
¿ You cannot delete menus between Edit and Tools on the menu bar. The area between these menu positions is reserved for context-sensitive menus that change depending on the active window. You can add menu items to menus between the Edit and Tools menus, but the new menu items will be swapped out of the menu when the context changes.
¿ Changes made to the menu system using this command are not saved; they are lost when you exit Quattro Pro. Each time you run a macro containing {DELETEMENU}, the menu changes appear again.
¿ To restore the original menu bar, use the macro command {SETMENUBAR} without an argument
{DELETEMENUITEM}
Syntax
DeleteMenuItem(MenuPath As String)
PerfectScript Syntax
DeleteMenuItem (MenuPath:String)
Description
{DELETEMENUITEM} removes the menu item specified by MenuPath from the menu system. Use {DELETEMENU} to remove entire menus from the active menu system.
Example
{DELETEMENUITEM "/Edit/Clear"} removes the Clear command from the Edit menu.
{DELETEMENUITEM "/Edit/<-"} removes the first item on the Edit menu.
Parameters
MenuPath Menu item in the tree to delete; enter the sequence of menu items separated by forward slashes (/); you can use <- and -> to specify an item menu at the top or bottom of a menu, respectively. For example, /File/<- specifies the first item on the File menu. You can also use numbers to identify menu items. For example, /File/0 specifies the first item on the File menu (the ID numbers start at zero).
Notes
¿ You can delete menu items from any menu, but if you change a context-sensitive menu (all menus between Edit and Tools on the menu bar), the change applies only to the menu in the active window. For example, suppose you use a macro to change the View menu when the notebook window is active. If you then open a chart window, the chart View menu appears--without the change. If you want the change to apply to that View menu as well, you must run the macro again.
¿ Changes made to the menu system using this command are not saved; they are lost when you exit Quattro Pro. Each time you run a macro containing {DELETEMENUITEM}, the menu changes appear again.
¿ To restore the original menu bar, use the macro command {SETMENUBAR} without an argument.
{DELVAR}
Syntax
DelVar([VarName1 As String], [VarName])
PerfectScript Syntax
DelVar ([VarName1:String]; {[VarName:String]})
Description
{DELVAR} deletes unused named variables. Named variables are used to control OLE objects. OLE objects are released from control at the end of macro execution, but named variables remain until you exit Quattro Pro. You can delete the unused named variables to free an object assigned to that name, and then control the object using another macro.
Example
{DELVAR} deletes all named variables
{DELVAR calc} deletes a named variable calc
{DELVAR calc 0, calc 1, calc 3} deletes the named variables calc 0, calc 1, and calc 3.
For more details on using {DELVAR} and other OLE automation macro commands, Using OLE Automation Features.
Parameters
VarName A named variable
{DESCR}
Syntax
DESCR(InBlock As String, OutBlock As String, [Grouped As String], [Labels_ As _DESCR_Labels__enum], [Summary_ As _DESCR_Summary__enum], [Largest As Integer], [Smallest As Integer], [Confidence As Double])
{DESCR} returns a table of descriptive statistics that characterize a sample. {DESCR} is equivalent to the Descriptive Statistics analysis tool.
Parameters
InBlock One or more numeric cell values representing the input cells
OutBlock Upper-left cell of the output cells
Grouped "C" to group results by column or "R" to group results by row; "C" is the default
Labels 1 if labels are located in the first column or row of the input cells; 0 if the input cells do not contain labels; the default is 0
Summary 1 to display summary statistics; 0 to omit summary statistics; the default is 0
Largest A value n which, if present, makes {DESCR} report the nth largest data point; if omitted, the largest data point is not reported
Smallest A value n which, if present, makes {DESCR} report the nth smallest data point; if omitted, the smallest data point is not reported
Confidence Confidence level of the mean; the default is 0.95
{DialogView}
Syntax
DialogView(Window As String)
PerfectScript Syntax
DialogView (Window:String)
Description
{DialogView} lets you edit an existing dialog box.
Parameters
Window Dialog window to make active
{DialogWindow}
Syntax
{DialogWindow.Property}
Description
{DialogWindow} is equivalent to right-clicking the title bar of a dialog window to set its properties.
{DialogWindow} commands affect the active dialog window. The next table lists the possible settings for Property. To display a property description with syntax, choose that property in the following list:
Dimension
Disabled
Grid_Options
Name
Position_Adjust
Title
Value
{DialogWindow.Dimension}
Syntax
{DialogWindow.Dimension<Option>}
PerfectScript Syntax
DialogWindow_Dimension_Height (Height:Numeric)
DialogWindow_Dimension_Width (Width:Numeric)
DialogWindow_Dimension_X (XPos:Numeric)
DialogWindow_Dimension_Y (YPos:Numeric)
Description
{DialogWindow.Dimension} is equivalent to the dialog window property Dimension, which lets you move and resize the active dialog window. Each argument is specified in pixels. XPos and YPos specify the distance in pixels from the left side of the Quattro Pro window and bottom of the input line, respectively.
Example
The following macro command positions the active dialog window two pixels from the left edge of the Quattro Pro window and five pixels below the input line, and sets the width to 150 pixels and the height to 250 pixels.
{DialogWindow.Disabled} disables (Yes) or enables (No) the active dialog box or Toolbar. This command works only when you view a dialog box or toolbar; it does not work when you edit one.
{DialogWindow.Grid_Options}
Syntax
DialogWindow_Grid_Options(Settings As String)
PerfectScript Syntax
DialogWindow_Grid_Options (Settings:String)
Description
{DialogWindow.Grid_Options} sets the grid size of the active dialog window. Use GridSize to specify the distance between grid points in pixels; ShowGrid specifies whether the grid is visible; SnapToGrid specifies whether objects snap to the grid.
Example
The following macro sets the distance between grid points to 10, shows the grid, and enables it.
{DialogWindow.Grid_Options "10,Yes,Yes"}
{DialogWindow.Name}
Syntax
DialogWindow_Name(Name As String)
PerfectScript Syntax
DialogWindow_Name (Name:String)
Description
{DialogWindow.Name} sets the name of the active dialog window. This name is used by macro commands, @functions, and link commands to identify the dialog box (or Toolbar).
{DialogWindow.Position_Adjust}
Syntax
DialogWindow_Position_Adjust(Settings As String)
PerfectScript Syntax
DialogWindow_Position_Adjust (Settings:String)
Description
{DialogWindow.Position_Adjust} specifies how the active dialog box resizes when the Quattro Pro window is resized. The arguments are equal to options in the Position Adjust dialog box; click here for directions on using the Position Adjust property.
{DialogWindow.Title}
Syntax
DialogWindow_Title(Title As String)
PerfectScript Syntax
DialogWindow_Title (Title:String)
Description
{DialogWindow.Title} specifies the title that appears on the dialog box when the user is viewing it (the title does not appear when editing the dialog box).
{DialogWindow.Value}
Syntax
DialogWindow_Value(String As String)
PerfectScript Syntax
DialogWindow_Value (String:String)
Description
{DialogWindow.Value} sets the initial settings of the dialog box (or Toolbar). You can use it with @COMMAND to find the current settings of the dialog box. String is a comma-separated list of settings. Each setting sets the initial value of one control. Control values appear in this list if their Process Value property is set to Yes. You can set the order of the settings while editing the dialog box.
Example
The following macro command sets the initial values of a dialog box with three controls. Each setting maps to one control.
{DLL} runs a macro or returns a value from an add-in @function contained in a dynamic-link library file. The @function can have up to 16 arguments.
Example
This statement calls the @function AMPLITUDE, included in the DLL Math, with two selections as arguments:
{DLL Math.AMPLITUDE,A1..A10,B1..B10}
Parameters
DLLName The name of a DLL file (if not already loaded)
FunctionName The name of an @function contained in the DLL
Argument1,Argument2... Arguments to the @function
{DLL.Load}
Syntax
DLL_Load(DLLName As String)
PerfectScript Syntax
DLL_Load (DLLName:String)
Description
{DLL.Load} loads a dynamic-link library (DLL) program. You can use {DLL.Load} to load a DLL containing add-in @functions or macros. When the DLL is loaded, you can reference add-in @functions contained in the DLL without typing the DLL name. Similarly, macros contained in the DLL become resident in memory.
You can use {DLL.Load} to define a startup macro in QPW.INI.
Example
{DLL.Load MYDLL} loads a DLL program named MYDLL
Parameters
DLLName The name of a DLL file to load
{DraftViewGoto}
Syntax
DraftViewGoto()
Description
Switches from either the Objects Sheet or the sheet in Page View mode to Draft View.
