Closes an application directory.
Syntax
RELEASE directoryname
Parameters
| directoryname | The 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
Marks the end of a transaction, discarding the results.
Syntax
ROLLBACK WORK
Comments
The ROLLBACK WORK command is the SQL equivalent of the QUITTRANSACTION command. The value of the system variable $InTransaction indicates if an explicit transaction is in progress; the ROLLBACK WORK command sets $InTransaction to 0 ($False).
See Also
$InTransaction
BEGIN WORK
COMMIT WORK
ENDTRANSACTION
QUITTRANSACTION
SET TRANSACTION FLOW
TRANSACTION
INTERSECT
Isolates the common members of two or more result sets.
Syntax
set1 INTERSECT set2
Parameters
| set1 | A result set produced from the execution of a set-producing command. All sets in the command must have the same component structure. |
| set2 | A result set produced from the execution of a set-producing command. All sets in the command must have the same component structure. |
Comments
When used within a FIND command, the result set contains the members that are common to each of the specified result sets, with duplicates eliminated.
See Also
FIND
MINUS
UNION
MINUS
Removes the members of one or more result sets from a another result set.
Syntax
set1 MINUS set2
Parameters
| set1 | A result set that resulted from the execution of a set-producing command. The sets must all have the same component structure. |
| set2 | A result set that resulted from the execution of a set-producing command. The sets must all have the same component structure. |
Comments
When used within a FIND command, the result set contains all members of set1 that are not also in set2, and so on.
See Also
INTERSECT
Set Specification
UNION
Syntax
$ProgramFileName
Return Value
Character string (varalpha). Cannot be reset by an application program.
Comments
Contains the file system name of the disk file that contains the currently executing program. AREAS.ZIM or DIRS.ZIM entries that apply to the file are expanded, as are the special prefix characters (i.e. #,),^,~,”).
See Also
$filepath
The size of the terminal screen in character columns.
Syntax
$screenwidth
Value
A number. Cannot be reset by an application program.
Description
$ScreenWidth gives the width of the terminal screen in character columns.
In graphic environments, the number of columns depends on the font and point size used in the application window (BACKSCREEN).
See Also
$ScreenHeight
System Variables
ThisWindow
The size of the terminal screen in character rows.
Syntax
$screenheight
Return Value
A number. Cannot be reset by an application program.
Description
$ScreenHeight gives the height of the terminal screen in character rows.
In graphic environments, the number of rows depends on the font and point size used in the application window (BACKSCREEN).
See Also
$ScreenWidth
System Variables
ThisWindow
The elapsed number of seconds since 12:00 am, 1 January 1970.
Syntax
$timesecs
Return Value
A number. Cannot be reset by an application program.
Description
The number of seconds that have elapsed since 12:00 am on 1 January 1970.
This variable is useful for measuring the number of seconds between two events.
See Also
$Date
$Time
A binary true value for comparison.
Syntax
$true
Return Value
Binary true (“1”). Cannot be reset by an application program.
Description
A “true” value for comparisons in logic expressions.
Example
if Event.ScrollingKey = $True
... commands ...
endif
See Also
$False
$Null
Portuguese 
English