R:BASE 11 for Windows

R:BASE 11 - Latest relational database elements

R:BASE 11 for Windows

R:BASE 11 is the new major release from R:BASE Technologies showcasing the latest advances for databases and applications. R:BASE 11 has been honed to combine pure performance and high-tech features with a practical interface for users of all levels.

R:BASE 11 users can achieve peak productivity to overachieve, outperform, and over-deliver on data management goals.

R:BASE

Product Features
(scroll down for recent additions):

  • Robust SQL Engine
  • 42 Years of Continuous Innovation
  • Temporary Tables and Views
  • Stored Procedures and Triggers
  • 512-Bit Built-in File Encryption
  • Form Designer with over 100 Controls
  • Report Designer with over 45 Controls
  • Label Designer with over 45 Controls
  • Sub-Reports and Nested Sub-Reports
  • Graphical Query Designer
  • Quick and Powerful Application Designer
  • Integrated File Gateway (Import/Export)
  • Simple to Use Form Wizard
  • Intuitive Report Wizard with Invoice template and Styles
  • Fast and Easy Label Wizard
  • INNER/OUTER JOINS with Nested JOINS
  • Query Wizard with True Graphic User Interface
  • Versatile Database Explorer
  • GUI Text Editor and Syntax Highlighting
  • Built-in E-mail Support for Reports
  • Built-in Image/BLOB Data Viewer/Editor
  • Built-in PDF Writer with 128-Bit Security
  • Built-in Bar Codes
  • Support for Custom Plugins/WinUDFs
  • Data Dictionary for Database Information
  • Trace Debugger with Watch Variables
  • SQL Queries at R> Prompt
  • Universal color palette with over 180 options
  • Form-level Themes, with support to load external themes
  • Ability to search for text in all database areas


The following new features are specific to R:BASE 11,
and are grouped by module:
Global Environment:
  • Updated GUI to better match the appearance of current operating systems
  • Enhanced NOTE data type to hold up to 10,000 characters
  • New Database Comments (stored as notes within file 1), which are available for review at the Database Explorer, Data Dictionary, and Databases Properties
  • New database stored static variables, which are automatically defined when the database is connected
  • Enhanced Color Editor dialog for background/foreground colors, object properties, and in other areas were a color may be selected
  • Enhanced R:Calculator plugin with history (persisted between sessions)
  • Enhanced Font dialog for designers, with font type preview and color customization
  • Added "Defaults" button for the R:BASE Startup Options
  • New CMDHIST setting to control the "Update Command History" check box, when running forms and printing reports/labels from the Database Explorer
  • Redesigned Data Dictionary utility

    • Preferred Tabs Location - places the tab at the desired top, bottom, left, or right edge
    • Linked Tables/Columns - when a table is selected in the Tables tab, it is preselected when viewing the Columns tab (for SYSTEM TABLES also)
    • Space Separated Values - includes a space directly after the comma, where the cursor can move between values with greater ease
    • Prioritize Tab Order - reorganize the tab stacking order with drag-and-drop
    • MDI Support - the utility recognizes the MDI setting, and will remain open while other areas of R:BASE are used
    • Content Refresh - when focus is switched back to the Data Dictionary, the content will automatically refresh (only in MDI mode)
    • Color Value Conversions - provides a "Color Tool" mechanism to convert RGB colors to numbers
    • Tab Navigation - the [Ctrl+Page Down] and [Ctrl+Page Up] hot keys allow the next/previous tab navigation
    • Color Identifiers - the tabs are organized with distinctive color identifiers (triangle in top right corner) to improve the readability
    • Theme Preview - the Themes tab includes a preview button to review the theme presentation
  • Enhanced Find in Files utility supporting multiple folder searches (including multiple drive letters)
  • Added ability to capture the Find in Files utility search results, where the file names can be copied, and also the file names, date/time modified value, and file size
  • Enhanced Database Versions utility supporting multiple folder searches (including multiple drive letters)
  • Enhanced Database Versions utility display with results matching the Hidden File and/or Hidden Folder criterion
  • New TJOURNAL setting to optionally generate a transaction processing journal file to track database changes associate`d with each COMMIT or ROLLBACK
  • Added ability to switch between Delphi or HTML RGB Hex notation for Custom Colors
  • Enhanced RBTI_TIMEOUT variable functionality to execute a routine in the form of a command file, RUN SELECT, or CALL to a stored procedure when a TIMEOUT occurs
  • Added sorted column background color within the Data Dictionary, to match the logic in the Database Explorer
  • Enhanced BLOB Editor where the file being edited is displayed in the title bar
Database Explorer:
  • New Find in list Filter to search for items within the work space
  • Support to directly edit a stored procedure's code from the Database Explorer
  • Added column for Views, listing the table/view source that each view is comprised of
  • Added "Expand Selection" and "Shrink Selection" menu options to the Command Files group
  • Enhanced results when searching for text in EEPs, object properties, and expressions, where the date/time stamp and version are provided
  • Added Plugins button to the main toolbar
  • Enhanced WHERE Builder when running a form or printing a report/label which contains slave tables, where "ARRANGE TableName BY ColumnName" parameters can be specified
  • Added display of slave tables when selecting to run a form or print a report/label from the main toolbar
  • Added support to edit a view in R:BASE Editor from the Database Explorer
  • New "Open Table WHERE..." and "Open View WHERE..." options added to the group bar
  • Added "Save" button when searching for text in EEPs, object properties, and expressions
  • Added display for the current INSERT/OVERWRITE status in the R:BASE status bar
  • Added support to edit a stored procedure declaration in R:BASE Editor
  • Added display of comments when running an external form from the main toolbar when no external form is selected
  • Added "Save EEP To Folder" menu option for Forms, Reports, Labels, and External Forms where the EEP code may be saved
Commands:
  • Added EXCEPT clause for the SELECT ALL command, to exclude a subset of columns from a query
  • New RESET command to retain the date/time for tables and views when generating structure information with the UNLOAD command
  • Enhanced LIST command which displays the last data modification date/time stamp, and the last schema modification date/time stamp, and comment for the connected database
  • New SET STATICVAR command to define static variables, which are part of a connected database
  • Enhanced DIR command to support sort ordering with ASC and DESC parameters
  • Enhanced PROJECT command with EXCEPT parameter support to specify columns that will not be included in the projected table
  • Support for local variables within MDI forms with SET VARIABLE MDI
  • Added CREATE INDEX support for NOT NULL (partial) indexes, where the index is populated with references to rows where the column value is not NULL
  • Enhanced LIST VIEWS which shows the tables/views that are used in each view
  • Enhanced COMMENT ON command to specify a comment for the connected database
  • New EXPLAIN command which outputs the optimizer selections for the specified query
  • Enhanced BROWSE and EDIT commands with EXCEPT parameter support to specify columns that will not be included in the Data Browser
  • Enhanced PRINT... OPTION SCREEN with additional parameters to disable the Find Text and Report Outline buttons, just like other enabled/disable buttons parameters
  • Enhanced GRANT user privileges allowing CREATE privileges on TEMPORARY TABLES to be separate from CREATE privileges on permanent tables
  • Enhanced LIST command to display QualKey columns
  • New DBCONN command which displays all applications (application, path, and file name) with connections to the connected database
  • Enhanced UNLOAD DATA command to specify custom quote and delimiter character values for ASCII/CSV formats
  • Enhanced LIST command which includes the number of views, stored procedures, forms, reports, and labels
  • Enhanced SHOW VARIABLE command which supports wildcard characters for the variable name, even when the =w parameter is present
  • Enhanced DEBUG setting variable debugging feature where a warning will display if a SET VAR declaration is executed when the variable already exists and the variable type changes
  • Added ROWS_PER_FILE parameter for the GATEWAY exports where the records may be broken up into separate files based on the quantity of records in each file
  • Enhanced GATEWAY EXPORT formula detection support for Excel formats to dismiss equal characters that exist in table values, which are not actual formulas
  • Enhanced ExtForm plugin to include a SET_VERSION_NUMBER parameter, where the version number for an external form can be adjusted/reset
  • Enhanced FEEDBACK setting where AUTONUM is added to the list of command which will show feedback
  • Enhanced GATEWAY IMPORT support for the XML format to flatten the structure and process attribute options for improved loading of data nodes
  • Increased size limit to 30,000 characters (was 10,000) for the SELECT...LISTOF function return value
  • Enhanced SELECT command functions (MIN, MAX, LISTOF, etc.) will now use up to the first 2,000 characters (was 80) for each NOTE value
  • Enhanced AUTOCHK command to check an index in descending order
  • Enhanced INSERT and LOAD commands with the ability to enable rebuilding of non-constraint indexes "after" rows are added, rather than row-by-row
Data Designer:
  • New Table Wizard

    • 32 available templates (Business/Personal)
    • Custom column definition (data type, not NULL) and ordering
    • Primary key definition (single/multiple fields), auto incrementing value
    • Table comment/description
    • Available SQL syntax
  • Added support to directly edit stored procedure code from the Triggers area
  • New menu options to create NOT Null Index definitions
  • Enhanced default column value capabilities, where static and global variable can be used
  • Added progress dialog to keep the user informed for structural changes to large tables
Forms:
  • Enhanced lasso frame for highlighting and selecting multiple objects easier
  • Added ability to roll back unwanted changes to variable definitions (one variable at a time) in the Expression Builder
  • Enhanced display of variable values within property editors and other areas for variable based controls, to help differentiate between variables
  • Added ability to assign an EEP or command file to an Enhanced DB Navigator button
  • Improved Tab Order settings window in tabular format
  • New Enhanced DB Navigator "Image Style" sets (Flat Gray, Flat Blue, Cute, Office, and Infographic) for use with new operating systems
  • New Default Form Settings tab to assign the default panes for Status Bar controls
  • Enhanced Bit Button and Push Button objects with Flat Face and Flat Shadow properties, for improved display in forms with backgrounds using darker colors
  • Enhanced right click context menu for the Custom Form Actions and controls to include the underlying Custom EEP options
  • Added "On Form Activate" and "On Form Deactivate" EEPs, which fire when the form receives focus, and when focus is moved to another form
  • Enhanced display for Pop-up Menus where zebra stripes can be enabled
  • Added Hint Expressions to List View and List Box controls to display a hint for the current mouse hovered row
  • Added "On Form Move" EEP, which fires when the form is moved
  • Added right click menu on the Tab Order listed items to allow quick editing of attributes or to show the property editor
  • Added right click menu on the Tab Order child items to filter the results by Read Only, Tab Stop, Enabled, and Component ID values
  • Enhanced Existing tab of the Object List toolbar to list the control hierarchy according to the tab order
  • Added Split View property to alter the separator line color
  • Added "Show Check Box" setting to the Enhanced Group Box form control, which specifies if the group box content is enabled/disabled
  • Added "Show Grid" property for the Enhanced Group Box form control to display a grid pattern on the box
  • Added application PROPERTY to alter Title casing behavior of hyphenated strings for form Edit/Memo controls
  • Check box support has been implemented for the Tree View and DB Tree View controls, where a check box is displayed next to the tree nodes
  • Enhanced DB Tree Grid properties to toggle what buttons may be displayed on the Navigator, including whether to display the button hints
Reports and Labels:
  • New Aztec Code 2-Dimensional Barcode type added
  • The Print Preview includes an optional Report Outline for quickly referencing data in large reports
  • Added Report Designer guidelines to assist users when placing/moving objects
  • The Print Preview window includes the "Report Outline" and "Find Text" buttons by default
  • New Report Designer zoom capability (slider object), for detailed reports
  • Added ability to roll back unwanted changes to variable definitions (one variable at a time) in the Expression Builder
  • Enhanced Edit toolbar with the display of variable values within the variable list, to differentiate variables
  • Added encoding types (ASCII, C40, Text, X12, EDIFACT, Binary, ASCII Manual, Auto) for 2D Barcode Data Matrix labels
  • Enhanced "Border" option to the Format toolbar
  • New "Grow to Height" and "Grow to Width" Options for Size toolbar
  • New display setting to show the Report/Label Designer margins with a custom color
  • Added 2D Barcode Data Matrix label settings (size of each Data Matrix module, rendered barcode as square)
  • Added File Delimiter options for "Print to Text File Setup" utility; SemiColon and Space
  • Added "Bring Forward" and "Send Backward" options to the Format toolbar and context menu
  • New Gradient button on the Draw toolbar to define gradient coloring for shape objects
  • Additional "align text within borders" options added to the Format toolbar
  • New "Column Balancing" setting added to the Page Setup > Layout tab
  • Enhanced navigation in the Print Preview with zoom and scrolling with the mouse wheel
  • Added Clear Selection button in the top left corner of the rulers to deselect any object
  • Enhanced Find in Print Preview search with a "Whole Word" option to locate text that is contained within a whole word
  • New Opacity setting for PDF Annotation labels to specify the amount of visibility for the annotation
  • Added right click context menu options to easily convert rich text objects to "advanced" rich text objects
  • New Prevent Orphans breakpoint setting which specifies whether group headers/footers can print alone at the bottom/top of the page
Trace Debugger:
  • Trace Prompt toolbar into which any R:BASE command may be manually entered and executed
  • Added right click menu option for when running a command file/EEP in the debugger, to insert a highlighted command into the R> Prompt Command History
  • New "Add Variable Value to Command History" Trace Debugger menu option to add complex ampersand variable commands to R> Prompt Command History
  • Added right click menu option for when running a command file/EEP in the debugger, to insert a highlighted command into the R> Prompt Favorites
  • Added right click menu option to copy highlighted text while debugging code
  • Enhanced Live Variable list sorting with ability to toggle the dynamic list in ascending, descending, and most-recent order
Functions:
  • New CVAL('LAST_MOD') function to return the date and time stamp (text) for the last modification made to the database data
  • New CVAL('LAST_SCHEMA_MOD') function to return the date and time stamp (text) for the last modification made to the database schema
  • New FISHER statistical function to return the Fisher transformation
  • New RANKAVG statistical function to return the statistical rank of a given value, within a supplied array of values
  • New RANKEQ statistical function to return the statistical rank of a given value, within a supplied array of values
  • Enhanced SELECT... LISTOF(ColName) function to support up to 10,000 characters
  • New CVAL('QUALKEY TABLES') function to return tables which contain a QualKey column
  • New CVAL('QUALKEYS') function to return columns assigned as a QualKeys
  • New CVAL('DBCOMMENT') function to retrieve the comments for a connected database
  • Enhanced CTXT function to support capturing VARCHAR data to a TEXT string
  • Enhanced SFIL function which can fill a NOTE data type value to the maximum size limit of 10,000 characters (was 4,092)
File Gateway:
  • Added support to import OpenOffice spreadsheet (.ods) files
  • Added support to export data to OpenOffice Text Document (.odt) files
  • Enhanced Export tab, where the Tables/Views combo box can be limited to tables, views, or both
  • Enhanced XML import support to flatten the structure and process attribute options for improved loading of data nodes
  • Added EXTRA_SHEETS parameter for the GATEWAY EXPORT XLSW option, which specifies whether blank sheets are included in the workbook
Stored Procedures/Triggers:
  • Added history for stored procedure searches
  • Enhanced drop trigger flexibility, to optionally drop a before trigger, or after trigger, separately
Query Builder/Query Wizard:
  • Enhanced Query Wizard allowing for multiple instances of a single table, for building self-referential constructs
  • Improved Create Alias dialog to better review computed column definitions
  • Added Query Wizard "Column Comments" option to toggle the display of comments for table columns in the wizard workspace
  • Added Query Wizard field selection dialog, with filter, for tables with many columns (drag field to the table name)
  • Added Query Builder/Wizard option to insert the continuation character (+) at the end of each line to easily recycle SQL code
R:BASE Editor:
  • Added right click "Add to Code Templates" context menu for highlighted text
  • Ability to review and edit the text attributes for the Syntax Scheme in use (cursor position)
  • Added right click "Add to R> Favorites" context menu for highlighted text
  • Added status bar pane showing the Syntax Scheme (R:BASE, Java, MS-DOS, etc.) in use
  • Enhanced file launch capability within the Compare by Content utility (double click file content)
  • Added "Default Font" menu setting to assign a font type and size to all word types (comments, strings, numbers, identifiers, keywords)
Data Browser:
  • Enhanced Update Query utility with a Query History to retain table queries
  • Added .xlsx file extension option for exports to Spreadsheets, similar to what is currently offered for Workbooks
  • Added "Enforce MDI Mode" setting to specify that the Data Browser is opened in MDI mode by default
  • New Find Panel in the Data Browser Tree Grid mode to provide fast record filtering
R> Prompt:
  • Enhanced Favorite Commands selection of multiple commands, where the result is concatenated for execution as a group
  • Added [Ctrl+Page Down] and [Ctrl+Page Up] Command History key combinations to place the focus to the bottom or top of the list
  • Enhanced console fonts, where the font name, style, and size are independent for the input console and output console
  • Enhanced Favorite Commands which interpret a double-click (equivalent to Run button), to run several commands in sequence
  • Added Favorite Commands right click option to copy the selected command to the clipboard
User Privileges:
  • Added ability to allow CREATE privileges on TEMPORARY TABLES to be to be separate from CREATE privileges on permanent tables
building robust systems for real time data analysis

Download the Evaluation Version!

  • 30-Day Free Trial
  • Explore New Features
  • Create New Database Systems
  • Convert Legacy Databases
Download

R:BASE Technologies, Inc. markets and supports the relational database management system; R:BASE, for application development and business use, along with a variety other database-related software products. The company adheres to three basic principles in the design of its data management products: high-performance, data integrity, and ease of use. This fundamental approach has kept R:BASE at the forefront of the industry as one of the most powerful relation DMS available, with millions of copies sold since its introduction.

SITE LINKS
SITE LINKS
SERVICES
SERVICES
QUICK LINKS
QUICK LINKS
Copyright © 1982-2024, R:BASE Technologies, Inc. All Rights Reserved.
Privacy Policy