Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Database Explorer

What's New

Scroll Prev Top Next More

As the main dashboard, the R:BASE 11 Database Explorer has been enhanced with the following features:

 

New Find in list Filter to search for items within the work space

 

FindInListFilter

 

 

Support to directly edit a stored procedure's code from the Database Explorer

 

EditSPCode

 

 

Added column for Views, listing the table/view source that each view is comprised of

 

View_TableList

 

 

Added "Expand Selection" and "Shrink Selection" menu options to the Command Files group, where a custom file mask (file name and/or extension) can be specified to include or limit what files are selected

 

ExpandShrinkSelection

 

 

Enhanced results when searching for text in EEPs, object properties, and expressions, where the date and time stamp and version are displayed next to the object name

 

FindInEEPs_DateVersion

 

 

Added Plugins button to the main toolbar

 

MainToolbar

 

 

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. After a slave table is selected from the table list in the WHERE Builder, the "ARRANGE BY" button is enabled to define the column(s) to arrange the slave table data.

 

WHERE_ArrangeBy

 

 

Added display of slave tables when selecting to run a form or print a report/label from the main toolbar

 

RunForm_TableList

 

 

Added support to edit a view in R:BASE Editor from the Database Explorer, where a tab opens in R:BASE Editor for any changes to be implemented by running the .vie command file

 

EditView\

 

 

New "Open Table WHERE..." and "Open View WHERE..." options added to the group bar

 

OpenTableViewWhere

 

 

Added "Save" button when searching for text in EEPs, object properties, and expressions, where each module may be saved individually

 

FindIn_Save

 

 

Added display for the current INSERT/OVERWRITE status in the R:BASE status bar

 

InsertKey

 

 

Added support to edit a stored procedure declaration in R:BASE Editor, with the source in a .PRO file and the declaration to a .RMD file

 

EditSPDec

 

 

Added display of comments when running an external form from the main toolbar when no external form is selected

 

RunEForm_Comment

 

 

Added setting to toggle the display of tables/views for the Views area. When enabled, the setting can slow down response times when many/complicated views are present.

 

DBExplorer_Settings_ShowViewTables

 

 

Added "Save EEP To Folder" menu option for Forms, Reports, Labels, and External Forms where the EEP code for the selected objects may be saved to a folder

 

GB_EForms_SaveEEP

 

 

Database Explorer features added within R:BASE X.5 (Versions 10.5):

 

Added "Open Table As" option to view a table as a Grid, Row, or Tree Grid. Under views, "Open View As" is also available.

Enhanced Property Bar including the "Find in Database Explorer" button

Enhanced dialog when running forms and printing reports/labels, where a "WHERE History" button is now displayed

Updated Database Explorer sidebar, with active tabs made more prominent

Added "search history" support for the Find in Database Explorer utility. The entry box is now a drop down where the search history is available in the drop down items. To clear the history, press the [Ctrl+R] key combination. The search history is saved in the C:\Users\<User>\RBTI\ folder within the DBEXP.RST file.

Added "search history" support for the Find in Custom EEP, Control Property, and Expression searches

Added "In Property Names" option for Control Property searches to locate text for the actual property (e. g. Read Only, AutoSize, Show Hint, etc.) in use for objects in forms, reports, and labels

New "Show Hidden Items" setting, to toggle the display of files, based upon the hidden file attribute. Hidden files may include databases, external form files, applications, and command files.

Added workbook export generation control option in Tables > Export Data > MS Excel Workbook

Additional Split View and Tile Menu menu control types added as options for application conversions

Enhanced display appearance with legacy application to external form file conversions

Enhanced "Find in Control Properties" [Ctrl-L] searches to include the Tree View and Drop-Down Menu Button "EEP File" properties

Added "File Comment" option for the Commands Files area, where braces {...} in the first line will be interpreted. R:BASE will only look for the first 1024 characters of the file. The setting must be enabled by selecting Settings > Database Explorer > Show File Comment

Added version number to the output file name when unloading forms, reports and labels, to allow easier tracking for unloaded items. The unloaded file name includes the database name, the item type, (Form/Report/Label), the form/report/label name, and the version number.

Updated Database Properties option to allow the dialog to be launched for all available database version flags. A help button was also added, so that version flag values and other database information may be reviewed.

Added "Update Command History" check box for when running external forms

Added option to reset a stored procedure version number

Added Database Explorer setting where users can toggle sending deleted files to the Recycle Bin or not. The default is enabled. File-based objects (external form files (.rff), application files (.rba), and command files) are already sent to the Recycle Bin. With this change, database files are now also sent to the Recycle Bin.

 

Database Explorer features added within R:BASE X (Versions 10.0):

 

Unicode support for extended characters for all Database Explorer objects

Support for Fractional Seconds (HH:MM:SS.SSS) for TIME and DATETIME data

New Database Explorer navigator, with left sided tabs, to only display menu options for the active module

New Database Explorer drop-down menu, to quickly jump to a desired module

Added "Date/Time" column for Table and Views providing the last structure change for each - R:BASE Enterprise only

Added option to display row numbers for tables, views, forms, reports, etc., with additional alignment settings

Added Database Properties reference in the Databases section, providing general information, database connections, table structure, column structure, and indexes for the selected database

Enhanced display of compressed forms, reports, and labels, which appear with a vice icon indicating if it is currently compressed, or no vice if uncompressed

Enhanced warning exclamation display of listed database files, informing users if a listed database is that of a version prior to R:BASE X - R:BASE Enterprise only

Additional drag-and-drop unload capabilities for tables, allowing users to unload table structure with [Ctrl]+Drag table and unload table data with [Shift]+Drag table. The file names of the unloaded table will reflect the unload type used.

Enhanced stored procedures unload capabilities to create the .PRO source file, and a .RMD file with the same name containing the PUT command, with full parameters

Added Connection History option to the group bar Databases menu

Enhanced "Find in Control Properties" utility to also locate text within Custom Form Actions

Added setting to show/hide slave tables for forms, reports, and labels

New "Database Events" menu item within the "Databases" options

Expanded Database Explorer settings, to "Open Group After Connecting" to include External Forms, Applications, and Command Files

New hot key [Ctrl+Alt+Q] allowing an EEP quick peek for a selected form/report/label

Added WHERE Clause History [F5] to keep track of the WHERE Clause statements used for forms, reports, and labels

Enhanced RBA Application conversion to an External Form, with Tree View as an additional menu display method

Added "Touch" utility for forms, reports, and labels to update/save objects when migrating between versions

Added "Read Only" notification added to the Status Bar when a database is connected in read-only mode

Added WHERE Clause History [F5] to keep track of the WHERE Clause statements used when opening tables/views

 

Database Explorer features added within versions eXtreme 9.0, 9.1, and 9.5:

 

Ability to convert R:BASE Windows and DOS legacy application file (.APP/.API) to an External Form File

Ability to convert R:BASE Windows application file (.RBA) to an External Form File

An additional menu option is available to copy a database to another folder location when right clicking on a database

New right click menu option to unload the structure of Server tables

New right click menu option to unload the structure of dBASE tables

The "Find in Files" utility includes additional Search options allowing the search for text to be more precise

A new feature within the "Forms" options allows for a Variable Form to be saved as an External Form File

Support to store Comment and Version information for External Form Files

The Group Bar options and the right click speed menu options have been synchronized to match

The "Find" options for the Forms/Reports/Labels/External Forms/Applications Group Bar menus and right click options now also contain "Find in Expressions... Ctrl+Shift+F" and "Find in Control Properties... Ctrl+L"

Enhanced Forms option to change the background color for multiple forms at once

Ability to search for text in Custom EEPs within Forms, Reports, Labels, External Forms, and Applications

Ability to search for text in within Form, Report, Label, and External Form control properties

Ability to search for text within defined Form, Report, and Label variable expressions

Support for drag-and-drop unload capabilities from any Database Explorer object to the Windows Explorer

Detailed lock status for connected databases and opened tables

Ability to cut, copy and paste (using [Ctrl]+[X], [Ctrl]+[C] and [Ctrl]+[V]) External Form Files, Command Files, and Application files into Windows Explorer

Ability to copy and paste (using [Ctrl]+[C] and [Ctrl]+[V]) single or multiple Forms, Reports, and Labels to and from the Database Explorer

Added "Date/Time" column for Forms, Reports, and Labels

Added "Version" column for Forms, Reports, and Labels

Multi-Select is available for all Database Explorer objects

Ability to search for text within Stored Procedures from the Group Bar

Renaming of Database Explorer objects using the [F2] key is enabled

Smart default output file naming conventions provided when unloading all Database Explorer objects

Ability to launch the R:BASE Editor for several selected command files

Enhanced legacy object conversion to support multiple forms, reports, or labels

Sort visualization enabled, by showing an "Asc/Desc" arrow within the column

Sort options are kept for each Database Explorer object group

New "Favorite Folders" feature within the Property Bar, to store common folder locations

New "Launch File Explorer" button within the Property Bar

New "Show in Group" button within the Property Bar for easier sorting of objects

New "Launch" option added to the Group Bar for Command Files

New "Show/Hide Grid Lines" button within the Property Bar

Added "Load/Unload" options added to the Group Bar for Forms, Reports, and Labels

Added "Compress/Uncompress" options added to the Group Bar for Forms

Added "Change Form(s) Theme" option added to the Group Bar for Forms

Added file "Properties" option for External Forms, Applications, and Command Files

Enhanced feedback display when copying a database greater than 10MB

Enhanced feedback display when copying a table with greater than 25,000 records

Added "Temporary Table/View" check box option when copying a table or view

New setting to add a WHERE Clause, change the browse mode, and use an MDI window when opening any table/view

The "Current Folder" displayed will act as an active link to launch the folder

 

Database Explorer features added within versions 7.x, Turbo V-8:

 

Moveable Splitter Bar to Adjust Panels to Your Preference

Single-Click Column Header Sorting

One Screen Viewing of all Pertinent Table Information

4 Viewing Modes including: Large Icons; Small Icons; List; and Details

Right-Click Speed-Menu options for Performing Common Tasks

Disconnect option for the Currently Connected Database

Stored Procedures Pane for making Stored Procedure Manipulation Easy

Current Folder Browser to Change Directories with Ease

Status Bar Displays System Information

Recent Connection History for Quick Maneuvering