R:BASE 7.6 for Windows is a completely new RDBMS environment which includes all the latest GUI features for every designer and wizard while utilizing the legacy of the R:BASE engine as a foundation of stability.

R:BASE 7.6 for Windows is completely compatible with R:BASE 6.5 for Windows as well as R:BASE 6.5 and higher for DOS databases. R:BASE 7.6 includes conversion menu options for existing Forms, Reports, and Labels; thus, saving you the overwhelming job of redesigning completely new ones.

Along with over 80 new Form objects and over 25 new Report objects, R:BASE 7.6 boasts: a fully re-engineered Database Explorer; R:BASE Editor; Drag-and-Drop QBE Query Wizard; Modularized Application Designer; Powerful File Gateway utility; Built-In Form, Report, and Label Wizards; a Multi-Level Interactive Trace Debugger; and an Integrated NOTE/VARCHAR/BLOB Data Manager.

Below are specific enhancements added since R:BASE 7.1 for Windows:


Main RBG76 Window:

·Re-Designed Toolbar to Show/Hide Captions  
·Re-Designed Toolbar to Show/Hide Toolbar itself  


Database Explorer:

·On-Click Data Export (Table/View)  
·On-Click Unload Structure (Table/View)  
·On-Click Unload Table Definition  
·On-Click Unload Table Definition with Constraints, Indexes, Comments, etc.  
·On-Click Unload Structure and Data  
·On-Click Load option for Load Form..., Load Label... and Load Report  
·Additional Setting: Double-Click to Open Designer  
·Additional Setting: SET WALKMENU interval  


File Gateway:

·Additional GATEWAY EXPORT Options to Create Colorful XLS Worksheets  
·Additional GATEWAY EXPORT options to Create a Multi-Page XLS Workbook  


Data Browser/Editor:

·Display Full Text as a Hint When You Mouse Over the NOTE Column  


Data Designer:

·A new "Relational Verification" option setting to check the relational integrity of data type for matching column names before the Data Designer is launched  
·Enhanced Data Designer  


Views:

·GROUP BY button was added to Query Builder  


General:

·Support for INNER JOIN keywords in syntax of SELECT  
·New Built-in 512-bit File Encryption for all OUTPUT > UNLOAD routines  
·Built-in File Encryption for all command files, EEPs, using RBEdit, Save, Save As ...  
·Customize Default Settings for Form/Label/Report Designers  
·Enhanced WHERE Clause to include the HAVING parameter  
·Themes for CHOOSE, DIALOG, and PAUSE commands  
·Automated Settings for SCRATCH files: SCRATCH TMP  
·All engine message files (.MSG) are now integrated in RBENGINE76.DLL. This is a major improvement in the history of R:BASE to increase network speed and helps maintain updates for network administrators.  
·Allow AUTOSIZE designer preference for Form, Label and Report Default Settings  
·Support for new LIMIT syntax: LIMIT [starting row], [number of rows to return] With two arguments, the first argument specifies the starting row to return, and the second specifies the number of row(s) to return. The initial row is 0 (not 1)  
·Support for new TOP n qualifier in SELECT commands. SELECT TOP n * FROM tablename WHERE whereclause ORDER BY column(s)  
·New PROPERTY command to suppress the -ERROR- message when the WHERE clause does not meet the criteria to display Pop-up Menu defined for DB and Variable Edits. PROPERTY <ComponentID> SuppressPopupErrorMessage 'TRUE'  
·New CVAL Function to returns the list of all available ports, separated by comma, on that workstation: (CVAL('PORTS'))  
·Support for moving GIFs when using OPTION ICON_FILE in PAUSE or DIALOG commands.  
·RGB color support for the PROPERTY command for BLINKCOLOR. PROPERTY <LabelComponentID> BLINKCOLOR '[R255,G0,B0]'  
·New GETVAL Function to returns the list of all available to either retrieve the number of active network adapters or to retrieve the IP address of a given active network adapter. (GETVAL('GetIPAddress','n'))  
·New SET RECYCLE operating condition to search for a suitable unused block, rather than always adding a new block to the end of the data file  
·New SET RBADMIN operating condition to allow RBAdmin, the R:BASE Network Database Administrator utility, to kick users from the database when needed.  
·New CVAL Function to tell you which table holds the last block in File 2. (CVAL('LastBlockTable'))  
·A new operating condition SET TRACE ON/OFF option has been implemented to execute TRACE (Interactive Command File Debugger) inside a command file to trace a block of code as defined. (CVAL('TRACE')) will return the current status of TRACE (Values: ON or OFF)  
·New #NOW System Variable to hold the current date and time  
·New CLEAR TABLE LOCKS command parameter for CLEAR command to clear all locks on tables  
·New DATE Functions DNW, DWE, IDIM, IDOY, ILY, IWOY  
·New string trimmimg Functions LTRIM, RTRIM, TRIM  
·New string manipulation function SLOCP to search TEXT, NOTE, and VARCHAR data  
·New string manipulation function SKEEP, SKEEPI, SSTRIP, SSTRIPI  
·Support for TOP and LEFT parameters for #WHERE, CHOOSE, DIALOG, PAUSE and PRNSETUP Commands  
·New commands REFF and DEFF to Run and Design External Form Files  
·Additional PLUGIN command options to match your application and form themes  
·Additional PRINT Command Options to customize Print Preview to match your application and form themes  
·Additional PRINT Command Options for ARRANGE BY when using Sub-Reports  
·Additional support for the SSQL comman din EEPs  
·Additional PROPERTY options for DB/VARIABLE Calendar controls  
·All Custom Form Actions and Custom EEPs (Forms/Reports) will now run in memory as compared to temporary files  
·USING paramlist increased from 9 to 18  
·USING paramlist string length increased from 48 characters to 4000  
·New ICAP Function for additional text manipulation  
·New (CHKCUR('cursorname')) Function to check for a declared cursor  
·New (CHKVAR('varname')) Function to check for a declared variable  
·Enhanced DROP Command  
·Enhanced UNLOAD Command  
·New WALKMEMU time interval setting for keystroke recofnition  
·Enhanced SET FEEDBACK command  
·NEW SET PROGRESS command  
·Additional GAUGE parameter for the PAUSE command  
·Relational enhancement for primary/foreign key CASCADE option to support UPDATE, DELETE, or BOTH  
·Enhanced LIST parameter to display CASCADE tables  
·New ProgressMessage command to free up resources in order to display PAUSE 3 messages  
·New MODAL parameter to launch a Form, Label or Report in a designer  
·New DLFREE and DLLOAD Functions  


RStyle:

·Completely Re-Engineered Graphical User Interface with Custom Settings  
·Fully integrated R:Style 7.6 with all reported enhancements requests  


Form Designer:

·New Drag and Drop Functionality  
·Themes (R:Themes)  
·External Form File Support  
·Custom hovering Mouse Cursor display  
·Form Caption Buttons  
·New Tab Set Control  
·Timer Form Property to initiate user defined events at intervals  
·New Form Opening Behavior Options  
·Additional DB Grid Options (Zebra Stripe and Sorter Icons)  
·Additional DBGrid Option for record number display  
·Custom Background Color upon focus for DB/Variable Edit and DB/Variable Memo controls  
·Additional Multi-Select Properties for Variable ListBoxes  
·Additional support for images in Variable and DB Lookup ListViews  
·Additional support for images in the DB TreeView Control  
·New Gradient Feature for DBGrid Column Titles  
·Multiline support in DB Grid titles and columns  
·Addition of PDF Viewer Control  
·Addition of Tab Set Control  
·Support for ActiveX Controls  
·Enhanced DB Grid with "On Click" Sort  
·Form Wizard to include the option for Scrolling Region  
·Speedy Combo-Boxes  
·Table-Level Custom EEPs  
·On Row Entry  
·On Row Exit  
·After Saving Row  
·After Leaving Row  
·Addition of Separator Control  
·Addition of Arrow Line Control  
·Addition of Form Status Bar Control  
·PickList (Pre-Defined Values or Expression) for DB Grid Control  
·Additional Properties for DB Edit/Variable Edit Pop-up Menus, including:  
·Show Lines  
·Title Font and Color  
·List Font and Color  
·Title Background Color  
·List Background Color  
·Addition of DB Lookup ListView Control  
·Addition of Variable Lookup ListView Control  
·New "On Focus EEPs" option for Tab Page and Enhanced Tab Page Properties.  
·Addition of RBTI_FORM_MODE form system variable to hold the value of current form mode, such as ENTER, EDIT or BROWSE  
·Addition of RBTI_FORM_DATATYPE form system variable to hold the data type of focused column DB Control on a form  
·Anchors has been introduced to specify how a control is anchored to its parent  
·Additional Properties for the DB Image, Variable Image, and Image Controls  
·On Click  
On Right Click  
On Mouse Enter  
On Mouse Over  
·On Mouse Leave  
·Additional option of "Default State" for DB CheckBox and Variable CheckBox Controls  
·Additional Option of "Vertical Spacing" for DB RadioGroup and Variable RadioGroup Properties  
·Additional Table level EEP options including "On Before Insert Row" and "On After Insert Row"  
·Additional DB Grid options for "Row Background Color Field" and "Row Font Color Field" to store the color name in your table  


Report Designer:

·Sub Reports  
·Report Actions  
·Before Preview  
·After Preview  
·Before Generate  
·After Generate  
·On Before Design  
·On Close Designer  
·Before Generate and After Generate Custom EEPs for All Bands  
·Support for PROPERTY Command for all Report Controls  
·Addition of Diagonal Line Control as part of Standard Controls tool bar  
·New RBTI_REPORT_NAME RBTI System Variable  


Report Outputs:

·General  
·Selective exclusion of types of elements from appearing in the exported document  
·Background images/watermarks and background color for the exported document  
·Built-in support for E-mailing  
·Built-in Web Reporting facilities, get your report ready for serving over the Internet/  
·Intranet in just ONE line of code  
·New option of XHTML  
·Enhanced Report Outputs:  
·PDF:  
·40 bit and 128 bit Standard Encryption  
·Document Security (Owner Password)  
·User Password  
·User Privileges (Printing, Copying, Modifying)  
·Table of Contents and Hyperlinks  
·Bookmarks  
·Page Layout (Single Page, One Column, Two Columns Left,  
·Two Columns Right)  
·Page Mode (Outlines, Thumbs, Full Screen)  
·Viewer Preferences (Hide Toolbar, Hide Menubar, Hide Window UI,  
·Fit Window)  
·Presentation Mode  
·TrueType Font Embedding  
·Rich Text Encoding  
·Save Images as JPEG or Bitmap  
·Text and Image Compression  
·Save Document information (Subject, Author...)  
·Reuse Image objects to minimize file size  
·HTML:  
·Table of Contents and Hyperlinks  
·Document Preferences to disable Right-Click, Copying, and more  
·Single file and multiple file output  
·Save Images as JPEG, GIF, or Bitmap  
·Lines, Shading and Rectangles without image files  
·Floating page Navigator!  
·Graphical Navigator!  
·Reuse Image objects to minimize file size  
·XHTML:  
·Table of Contents and Hyperlinks  
·Document Preferences to disable Right-Click, Copying, and more  
·Single file and multiple file output  
·Save Images as JPEG, GIF, or Bitmap  
·Lines, Shading and Rectangles without image files  
·Floating page Navigator!  
·Graphical Navigator!  
·Reuse Image objects to minimize file size  
·RTF:  
·WYSIWYG output!  
·WYSIWYG editable RichText embedding  
·Save Images as JPEG or Bitmap  
·Save Document information (Subject, Author...)  
·Excel:  
·Images, Shapes, and Lines  
·Saving Images as Bitmap or Windows Metafile  
·Fonts with Font styles and Charset information  
·Report as Excel Workbook  
·Text formatting  
·Column and Line Spacing  
·RichText as WYSIWYG Image or plain Text