The last/current status code is shown in the editor window’s status bar at the bottom of the window for the open file, and appears red if the last status was not zero. | |
Placing the mouse cursor over the status code shows a description of the status and what operation caused it. You can also click the display in red in order to display the full help for the status code. See To get help for a status code for more information. | |
When your cursor is in the input area on the main window of Function Executor, the status bar displays the offset within the buffer: the hex, the decimal, and the ASCII value of the byte you are presently on. | |
The status bar also indicates how many operations have been performed when there are multiple items in the queue. Normally this displays 1 of 1, but if you are executing multiple operations, it will display the count as the operations are executed. | |
The status bar also displays when you are in a transaction. |
Control | Description |
---|---|
Repeat | Allows you to repeat commands. |
Create | Allows you to create a new file. |
File Statistics | Gives information from the BSTAT function. You can print these statistics. |
MDI | The Multiple Document Interface permits the opening of multiple files. |
Reset | Reset Client ID |
Stop | Btrieve Stop |
Version | Btrieve Version |
GUI Object | Description | Related Information |
---|---|---|
File menu | Allows you to perform the following commands and Btrieve operations: •Login and Logout •Open and Close •New •Print Setup •Set Owner Name and Clear Owner Name •Start Continuous Operations or End Continuous Operations •Reset, Stop, and Exit | |
Get menu | Allows you to perform the following Btrieve operations: •Get First and Get Next •Get Previous and Get Last •Get Greater Than and Get Greater or Equal •Get Less and Get Less or Equal | |
GetExt menu | Allows you to perform the following Btrieve operations: •Goto Percent •Get Position •Find Percent | |
Step menu | Allows you to perform the following Btrieve operations: •Step First and Step Next •Step Previous and Step Last | |
Updates menu | Allows you to perform the following Btrieve operations: •Insert, Update, and Delete You can also release locks using this menu. | |
View menu | Allows you to display GUI elements: •Toolbars (main and transactions) •History window •File statistics window •Engine version using the Btrieve Version operations | |
Tools menu | Allows you to perform the following Btrieve operations: •Get Directory and Set Directory | |
Window menu | Allows you to perform windowing operations: •Cascade windows and Tile windows •Select from a list of open windows | |
Help menu | Allows you to select from a list of help resources for this tool. | |
Open | Displays a dialog box from which you select a Btrieve file to open. | |
Create | Displays a dialog box with which you can create a new Btrieve file. | |
Reset | Resets the current client connection (Btrieve operation 28) and closes all files opened with that client ID. | |
Stop | Ends transactional operations (Btrieve operation 25) and closes all open files. | |
Statistics | Displays a dialog box listing the currently opened file’s statistics. You can print these statistics to a text file or save them to a description file usable by BUTIL -CREATE | |
Version | Displays information about the version of Zen (using Btrieve operation 26) that you are running. If no file is open, you will see information about the requester DLLs and any local MicroKernel engine. If you open a file on a remote server, you will see information about the server and requester DLLs. | |
Status Codes Help | If no file is open, displays Status Codes help file. If file is open and a status code is active, displays help for that particular status code. | |
Show help | Toggles whether a pop-up dialog box displays when a non-zero status code is received. | |
Show history | Toggles whether the History window is displayed. | |
Operation count | Indicates the current operation number. This is used when you set the Repeat to a value greater than one. | |
Transaction state | Indicates the current state of any transactions. Can be: •Blank, if no transaction is in effect •Concurrent •Exclusive |
GUI Object | Description | Related Information |
---|---|---|
Title Bar | Lists the full path of the open data file. | |
Data Buffer | Specifies a data value. For read and write operations, the Data Buffer contains records. For other operations, the Data Buffer contains file specifications, filtering conditions, and other information the database engine needs for processing the operation. This control corresponds with the Data Buffer parameter. | |
Key Buffer | Specify the path for the data file for which you want to perform a Btrieve operation. | |
Step vs. Get | Toggles between Step and Get operations | |
Get/Step First | Performs the Get or Step Next operation | |
Get/Step Prev | Performs the Get or Step Previous operation | |
Get/Step Next | Performs the Get or Step Next operation | |
Get/Step Last | Performs the Get or Step Last operation | |
Get Equal | Performs the Get Equal operation | |
Get Less Than | Performs the Get Less Than operation | |
Get Greater Than | Performs the Get Greater Than operation | |
Get Less or Equal Than | Performs the Get Less or Equal Than Operation | |
Get Greater or Equal Than | Performs the Get Greater or Equal Than Operation | |
Get/Find Percent | Performs the Get or Find Percent operations | |
Insert | Performs the Insert operation | |
Update | Performs the Update operation | |
Delete | Performs the Delete operation | |
Cancel | Cancels the recent changes | |
Unlock | Releases any locks. | |
Set or Goto Bookmark | Sets or positions at a previously defined bookmark. | |
Key Num | For most Get operations, specifies a key number, or index path, to follow for the current operation. For other operations, specifies such information as file open mode, encryption, or logical disk drive. This control corresponds with the Key Number parameter. | |
Key Only | Specifies to get key only, not data. | |
Repeat | Repeats the operation the number of times you specify. | |
Locks | Specifies the locking behavior you want in for the current operation. | |
Op Code | Specifies the current operation code plus its bias (if any). The default is 0. If you are familiar with Btrieve operation codes, you can enter the desired code. Otherwise, use the List box to specify an operation. This control corresponds with the Operation Code parameter. | |
Execute button | Performs the currently specified operation. | |
Operations list | Lists all Btrieve operations and their codes. The default is Open (0). You can move quickly through the list by entering the first letter of the operation you want to perform. | |
DataLen | Specifies the length (in bytes) of the Data Buffer. The default is 1024. For every operation that requires a data buffer, you must specify a buffer length. On many operations, the database engine returns a value to the Data Length. Generally, you should always specify a Data Length before you execute an operation. This control corresponds with the Data Buffer Length parameter. | |
Status Code Indicator | Displays a numeric status code returned by the database engine and a brief message explaining the result of a Btrieve operation. For detailed information about these status codes and messages, refer to the Status Codes and Messages manual. | |
Continuous Operations Indicator | Displays the following on the bottom row of the file window if the file is in Continuous Operations mode (operation 42). |
GUI Object | Description |
---|---|
Server | Specifies the server where the database resides that you wish to log in to or log out from. Note that a server name is required to access a database on a Linux or macOS operating system. See also Database URIs in Zen Programmer’s Guide. |
Database | Specifies the database on the server to which you want to authenticate. |
User Name | The user name you want to authenticate against the database. |
Password | The password for the user name. |
Client ID | If you want this login or logout to apply to a specific client ID, click Use and specify the range. Otherwise, leave as is. See Client ID in Btrieve API Guide. |
URI String | As you enter information in the forms, the URI resulting from your selections is shown in this area. |
GUI Object | Description | Related Information |
---|---|---|
Filename | Sets the location and name of the file that you want to open. | |
Owner name | Serves as a password for the Btrieve file, which is required to gain access to the file. A short owner name can be up to 8 bytes. The length of a long owner name depends on the file format. For more information, see Owner Names. | |
Mode | Sets the state of the file when it is opened. Based on the state, the database engine knows certain conditions that apply to the opened file. For example, a condition could be that the file can be read but not updated (read-only). | See Btrieve API Guide for an explanation of modes. |
Client ID | If you want this login to apply to a specific client ID, click Use and set the range. Otherwise, leave as is. | |
Sharing | The database engine ignores the Sharing options. The Sharing options applied only to a legacy version of the engine, Btrieve 6.15. |
GUI Object | Description | Related Information |
---|---|---|
Filename | Sets the location and name of the file that you want to create. | |
Owner name | Serves as a password for the Btrieve file, which is required to gain access to the file. A short owner name can be up to 8 bytes. The length of a long owner name depends on the file format. For more information, see Owner Names. | |
Mode | Sets the state of the file when it is opened. Based on the state, the database engine knows certain conditions that apply to the opened file. For example, a condition could be that the file can be read but not updated (read-only). | See Open Modes in Btrieve API Guide for an explanation of modes. |
Client ID | If you want this login to apply to a specific client ID, click Use and set the range. Otherwise, leave as is. | |
Sharing | The database engine ignores the Sharing options. The Sharing options apply only to a legacy version of the database engine, Btrieve 6.15. |
GUI Object | Description | Related Information |
---|---|---|
Key and Segment commands | Allow you to add or delete a key or to add, insert, or delete a key segment. | |
File Specifications | Displays and allows you to modify characteristics of the file. | |
Statistics | Provides read-only information about the file. | |
Key and segment matrix | Displays the keys and segments for the file, listing the starting position, length, attributes, and data type for them. Clicking a row allows you to see, and modify if you want, information in the Key and Segment blocks. | |
Key | Displays and allows you to modify characteristics of a key. | |
Segment | Displays and allows you to modify characteristics of a key segment. | |
Command buttons | Allow you create a data file, a description, or to cancel the dialog box. |
GUI Object | Description | Related Information |
---|---|---|
Main application window | Main features of the program. | |
Transaction type | Specifies whether you want an exclusive or concurrent transaction. | |
Lock information | Specifies the type of locking you want in the transaction. | |
Start transaction button | Starts a transaction. | |
Commit transaction button | Commits the active transaction. | |
Abort transaction button | Cancels the active transaction and rolls back any changes made. | |
File area | This area contains one or more open files. | |
Transaction indicator | Indicates whether you are currently in a transaction. If you are in a transaction, this display will show either Concurrent or Exclusive. |
GUI Object | Description |
---|---|
File information | Displays statistical information about the file. |
Flags | Allows you to view the flags set for this file. Any flag that is set will have a check mark next to its listing in the dialog box. |
Keys | Allows you to view the keys defined in this file. |
Key legend | Describes the single letter values that indicate Key attributes for the file. •D = DUP (Duplicatable) •M = MOD (Modifiable) •R = REPEAT_DUPS_KEY (repeating duplicates key) •A= NUL (All segment Null key) •L = MANUAL_KEY (any segment null key) •< = DESC_KEY (descending key value) •I = NOCASE_KEY (case-insensitive key) See also Key Attributes in Zen Programmer’s Guide. |
Print button | Allows you to print the file statistics. Set up the printer using the File menu. |
Save button | Allows you to save the current file statistics to a description file, which you can later use to make a new file with the same characteristics. |
Exclamation point (create new file) | Allows you to create a new file based on these file statistics. |
GUI Object | Description | Related Information |
---|---|---|
File menu | Allows you to perform the following operations: •Import a history file •Export a history file •Close the history window | |
Settings menu | Allows you to specify the visual attributes of the History window. •Save on Exit - specifies whether you want your customization of the History window to be saved between sessions. •Defaults - Resets the History window to default settings. This removes any settings you specified. •Docked - Toggles the state of the History window between a separate window and one that is attached to the Application Window. •Stay On Top- toggles the state of the History window between one that can lose focus and one that cannot. | |
Execute command | Loads the History Playback window | |
List of operations | Lists operations that you have recently performed. Each operation is logged with the following information: •FileID •Operation name or number depending on the status of the OpCodeNames check box. •Status code when that operation was performed •Number of times that operation was performed. •Key number set for the operation. •Contents of the key buffer. •Contents of the data buffer. | |
Logging | Toggles the inclusion of future operations in the history list. | |
OpCode Names | Toggles the display in the Operation column between operation code names (such as B_OPEN) and operation code numbers (such as 0 for B_OPEN) |