BOTTOM

Makes the last member of a result set the current member.

Syntax

BOTTOM [setname]

Parameters

setname

The name of a result set. If a setname is not specified, the current set is used.

Example

To find all Employees with Jones as a last name, to identify the result set as KeepName, and to set the current member pointer to the last member of KeepName, enter

find all Employees where LastName = “Jones” -> KeepName

bottom KeepName

To move the current member pointer to the last member in the current set, enter

bottom

 

See Also

$currentmember

DOWN

LOCATE

NEXT

UP

PRINT REPORT

Prints or displays a graphical reports previously created.

Syntax

PRINT REPORT name TO destination

Parameters

name

The name of a Zim document that contains the graphical report.

destination

The destination can be the SCREEN or to the PRINT.

Comments

The Zim document specified by name must contain a graphical report previously generated by a REPORT FROM command with the GRAPHIC option. The document can be printed any number of times.

If the destination is the printer, the report is printed automaticaly without operator’s intervention.

If the destination is the screen, the report can be visualized and then, optionally, printed and/or written to a PDF format file.

Examples:

PRINT REPORT MyDoc TO SCREEN

PRINT REPORT AnotherDoc TO PRINT

 

See Also

$getproperty

$printersetup

$screenprint

$setproperty

FORM REPORT

SET OUTPUT

PRINT

Prints the contents of a window or application document.

Syntax

PRINT name

Parameters

name

The name of a window (GUI environments only) or application document.

Comments

If name identifies a window, the window must be open and activated. The visible portion of the window is sent to the current output destination as a bitmap. Bitmap output can be produced in a GUI environment only.

If name identifies an application document, the application document is sent to the current output destination as a text file.

 

See Also

$getproperty

$printersetup

$screenprint

$setproperty

FORM REPORT

SET OUTPUT

RightClick

The right mouse button can be used to generate a RightClick event when a widget has the “RightClick” transmit property. The RightClick transmit property can be set in the Zim Screen Painter. Widgets that have the RightClick property cause FORM INPUT to terminate when they are clicked by the right mouse button. When the RightClick property causes FORM INPUT to terminate, the event structure’s EventName is set to “RightClick”, the Event.EventType is set to formfield ,and the Event.EventTag is set to the tag of the formfield that was clicked on. A right mouse click does not change the current field, and is detected only if it occurs on a widget in the current graphical window.

RightClick Event Information

The $MouseSubscript, $MouseFieldNum and $MouseFormNum variables now contains information about the field that was right clicked upon.

 

See Also

$RightClickMenu

SCREEN RESET

Resets the application window (BACKSCREEN) by re-displaying all active windows over it.

Syntax

SCREEN RESET

Comments

The SCREEN RESET command reverses a SCREEN CLEAR command by hiding the application window (BACKSCREEN) beneath all other active windows and making it the least current window.

During an input request, the Ctrl-R key sequence entered by the user has the same effect as SCREEN RESET.

Example

SCREEN RESET

is equivalent to the following sequence of commands:

window clear backscreen

window set not current backscreen

window display backscreen hide

screen clear   % clear prev. data & expose application window

output “Output to printer? (y/n)” ;

input Response

if Response = “y”

set output printer

endif

screen reset

 

See Also

FORM INPUT

CFT

Changes, with data from the terminal, any EntitySet, relationship with fields, form, or result set, prompting with field names and existing values.

Syntax

CFT [object [field]]

Parameters

objectThe name of an EntitySet, relationship with fields, form, or result set. A role name can be used. If omitted, the current set is used.
fieldA target field in object. If omitted, the software prompts for all fields in object in their defined order.

Comments

CFT object is short for CHANGE object FROM TERMINAL PROMPT.

Example

cft EntitySets

EntName  AvgSz  EntType  DirName

Employees   0

See Also

AFT

AFT

AFT (Add From Terminal)

Adding Data from the Terminal to an EntitySet or Relationship

Overview

The AFT command allows users to add data from the terminal to any EntitySet or relationship with fields. This command is interactive, prompting users to input data for specified fields.

Syntax

AFT [object [field]]

Parameters

  • object: The name of an EntitySet or relationship with fields. A role name can also be used.
  • field: A target field in the object. If omitted, the software will prompt for all fields in the object in their defined order.

Comments

  • AFT field stands for ADD object FROM TERMINAL PROMPT. This command is designed to facilitate data entry directly from the terminal, making it easier to populate fields interactively.

Examples

Example 1: Adding Data to an EntitySet

To add data to an EntitySet named Ents, you would use the following command:

aft Ents

EntName  EntType  AvgSz  DirName

:

This command will prompt you to enter values for EntName, EntType, AvgSz, and DirName in sequence.

Example 2: Adding Data to Specific Fields

To add data to specific fields in an EntitySet named Customers, you would use the following command:

aft Customers LastName FirstName TelNum

LastName  FirstName   TelNum

:

This command will prompt you to enter values for LastName, FirstName, and TelNum in sequence.

Usage Tips

  • Ensure that the object name is correctly specified to avoid errors.
  • If you omit the field parameter, be prepared to enter data for all fields in the object in their defined order.
  • Use role names if applicable to simplify the command.

By using the AFT command, you can efficiently add data to your EntitySets or relationships directly from the terminal, streamlining your data entry process.

See Also

CFT

RELEASE

Closes an application directory.

Syntax

RELEASE directoryname

Parameters

directorynameThe name of an application directory.

Comments

The RELEASE command closes the specified directory by removing it from the directory list, freeing the memory where the symbols defined in the directory were stored. Objects (and their data) belonging to the specified directory are no longer accessible.

Example

access DevDir update

access ProdDir read

add DevDir.Employees from ProdDir.Employees

add DevDir.Departments from ProdDir.Departments

add DevDir.Projects from ProdDir.Projects

release ProdDir

The preceding commands copy data from a production database to a development database, then close the production database so that subsequent commands are sure to affect only the development database.

See Also

$dirpath

ACCESS

pt_BRPortuguese