Database
•Connect... - prompts to connect to a database
•Disconnect - disconnects from the currently connected database
•Connection history - provides a history of previously connected databases
•Exit R:BASE - exits R:BASE
File
•New Query - creates a new query
•Open View - opens an existing view in the Query Builder
•Save View - saves the current view
•Save Query As View... - saves the current query as a view
•Save Query As Temporary Table... - saves the current query as a temporary table
•Save Query As Table... - saves the current query as a table
•Close - closes the Query Builder
Query
•Add Table/View - adds the currently selected table from the List of Tables to the Tables In Use
•Remove Table/View - removes the currently selected table from the Tables In Use
•Copy Syntax - sends the SQL statement to the Windows clipboard
•Column Aliases... - opens the Create Alias window to assign to assign alias names to existing column names in the query
•Select Columns... - opens the Select Columns dialog window to select columns and change the order of selected columns of Tables In Use
•WHERE Clause... - opens the WHERE Builder dialog to alter or create a WHERE Clause
•GROUP BY Clause... - opens the GROUP BY dialog to alter or create a GROUP BY Clause
•ORDER BY Clause... - opens the ORDER BY dialog to alter or create an ORDER BY Clause
•Browse Query - opens the Data Browser window to display the results of the query
•Print Data - sends the query results to the desired output
•Query Builder Settings... - opens the Query Builder Settings dialog to define how the table relation in queries are established
Tools
•Add/Remove Watch Variables - presents the Watch Variable dialog for you to select variable values to monitor
•Show/Hide Watch Variable List - toggles the display of the Watch Variable List, which remains visible during processing
•Data Dictionary - displays the Data Dictionary for finding database information
•BLOB Editor - displays the BLOB Editor to create and edit binary files
•Scratch Pad - displays a scratch pad window to hold any text that is frequently used or wanted to use as a reference during development
•R> Prompt... - opens the R> Prompt window
•Database Explorer - opens the Database Explorer
•R:BASE Editor - opens the R:BASE text editor
•Browse/Edit Table - presents the Data Browser for viewing data within a table or view
•Query by Example... - opens the Query Builder to query table data
•File Explorer - opens the Windows Explorer for navigating to and opening files
•Launch... - launches a file based on its existing file association
•Database Connections - displays the current number of connections to the database, with the option to reset the user count
Settings
•Startup Options... - customizes how R:BASE starts
•Database Explorer - changes the appearance and behavior of the Database Explorer
•R:BASE Editor... - customizes the R:BASE Editor
•R> Prompt... - change the appearance of the R> Prompt
•Data Browser... - change the font and colors within the Data Browser
•Data Designer
•Relational Verification - verifies the table's relation integrity. If checked, the relational verification of data type for matching column name will be validated while in the Data Designer, not when the table is saved. The default is set to OFF. If unchecked, the relational verification will be performed when saving the table.
•Warn When in Multi-User Environment - displays a warning when the Data Designer is launched and other users are connected to the database
•Column Name Template - provides a default value when adding new columns to tables
•Form Designer... - customizes the Form Designer Default Settings
•Report/Label Designer - customizes the Report/Label Designers Default Settings, as well as the Report Email Settings
•Application Designer - Create Backup Copy - creates a backup copy of an R:BASE application file (.rba), using the .rb~ file extension
•BLOB Editor... - alters the BLOB Editor default settings
•Hint Settings... - set the default settings for all pop up hints
•Walkmenu Time Interval... - sets the WALKMENU time interval for keystrokes
•Default Printer Font... - provides the default font for printing
•ROSK Settings... - provides settings for the R:BASE On-Screen Keyboard
•Input Language... - specifies the keyboard input language
•Custom Colors - allows users to save and load custom colors from one development computer to another
•Registry Settings - allows users to save and load custom R:BASE environment settings from one development computer to another
•Warn When Closing R:BASE Session - displays a warning when closing the R:BASE session
•Show Check Box to Suppress Error Messages - places a check box in all error message windows allowing you to suppress the error message(s). After selecting to suppress the error messages, you will not see any error messages within the entire R:BASE environment. In order for error messages to be displayed again, you must restart R:BASE or issue the "SET ERROR MESSAGES ON" command.
•Clean Scratch Files on Exit - deletes any remaining temporary scratch files (.$$$) after R:BASE closes
•Show Comments in Table/Field List - displays comments/descriptions with property editors and table listing dialogs
•Configuration Settings... - alters the settings stored in the R:BASE configuration file
Utilities
•Integrity Check - performs an integrity check for the connected database, using AUTOCHK
•Reload... - reloads and builds the database to a new name, using RELOAD
•Pack in Place - recovers unused disk space for the schema, keys, or all within the database, using PACK
•Pack Passwords - recovers unused disk space for the system passwords, using PACK
•Pack Index - recovers unused disk space for database indexes, using PACK
•R:Backup - launches the R:Backup database backup utility
•XML To Data Packet - prepares a data packet file from an XML file, by selecting the node containing the data/rows, for importing into R:BASE
•Connect SQL Data Source... - connects to an ODBC data sources via a DSN
•Disconnect SQL Data Source... - disconnect any currently connected SQL Data Source
•Attach SQL Database Tables - attaches tables from currently connected SQL Data Sources
•Detach SQL Database Tables - detaches tables from currently connected SQL Data Sources
•Convert Extended ASCII In Objects To UTF-8... - converts database and application projects that use extended ASCII characters
•Take a Snapshot - takes a screen shot of the R:BASE window or current screen to paste into another program
•Set Working Directory... - sets the current working directory
•Plugins - displays the installed R:BASE Plugin modules
•Map Network Drive... - maps a network drive
•Disconnect Network Drive... - disconnects a currently connected network drive
•Add Printer... - presents the Windows "Add Printer" dialog for adding a new printer
•Find in Files... - opens the built-in Find in Files search utility for finding text within files
•Database Versions... - scans the provided folder for databases, and lists the file, path, and version information
•Run... - prompts for the location and file name of the program you want to run
•Magnifying Glass - displays a Magnifying Glass lens that produces a zoomed display of the R:BASE environment
•On-Screen Keyboard - displays the R:BASE On-Screen Keyboard (ROSK)
•Set User ID and Password - prompts to enter a user identifier and password
•User Privileges... - displays options to grant and revoke privileges to users
Window
•Cascade - cascades the current window group
•Tile Horizontal - horizontally tiles the current window group
•Tile Vertical - vertically tiles the current window group
•Minimize All - minimizes the current window group
•MDI Windows - displays the list of opened MDI windows
Help
•Table of Contents - displays the R:BASE in-line help documentation
•Help Index - provides an index keyword search of the help
•Help Search - provides a word search of the help
•R:BASE Tutorial - opens the R:BASE Tutorial
•R:BASE Home Page - opens the R:BASE Technologies, Inc. home page
•Product Registration... - opens the product registration web page
•Product Activation - displays specific software information, such as registration number, seat count, license key, and activation key
•Check for Updates - opens the product updates web page
•R:DCC Client - opens the online database for users to submit and track reported bugs and enhancements requests for R:BASE
•Show License - displays the R:BASE license agreement
•File Versions... - displays a list of files that are opened by R:BASE, including operating system dynamic link libraries and R:BASE plugins
•About R:BASE - displays the R:BASE version and build
