R:BASE still leads the competition in functionality, speed, stability, power and sophistication. If you are developing or working with mission critical applications that demand these critical elements then R:BASE is your only choice.

Since its introduction in 1981 as the first PC-based database management system based on the relational model, R:BASE has led the database industry with a number of significant technological innovations. These innovations include being the first 32-bit DBMS in its class, programming-free application development, automatic multi-user capabilities, 4GL (a full-featured programming language in the R:BASE base product) and embedded ANSI SQL. And now we've added more new features to enhance the applications you develop in R:BASE.

New Usability features give end-users more intuitive interfaces and increased functionality from R:BASE applications. Features like clickable images give R:BASE applications a better look and make them easier to use. Improved user-defined functions give you direct control for specifying your own function with the R:BASE programming language.

New features in R:BASE give your applications more functionality. Stored procedures and triggers allow your applications to run complex calculations, check data, and run functions at your command or even automatically, when new data is input, updated, or deleted. Since your stored procedures are ODBC compatible, they can be executed in ODBC compatible database applications. New features like these make applications you develop more automatic and easier to use for your clients and users.

R:BASE for Windows maintains compatibility with other data formats including full compatibility with ODBC Level 2 and with The OTERRO Database Engine. You can use the same database you've created and maintained with R:BASE with other ODBC compatible applications like those written with Visual Basic, C++, Delphi, and Access.

If you've stayed current with R:BASE, the AUTOUPGRADE setting allows you to easily and quickly convert your 6.0 database to a current version database. Even if you don't have the latest version of R:BASE, you can still upgrade your database. And with all these great new features why would you want to wait any longer?

R:BASE's powerful database engine lets you query large amounts of data that other applications can't. And you're never limited to menu listings in R:BASE; because you can run customized queries with the R> prompt command. Create comprehensive forms and reports easily and change them at a moment's notice.

The use of primary/foreign key constraints with cascade (referential integrity) ensures that relationships between records are valid and that related data isn't accidentally or intentionally deleted. R:BASE also has some of the most comprehensive database security features available. SQL GRANT/REVOKE commands allow you to assign access rights to any database table.

No network server file to set up. Use your database over a network without fear of data corruption or data loss. With features like automatic concurrency control and automatic row level locking, R:BASE protects data in a network environment even while multiple users edit the same row or record. Accessing R:BASE on the network is as simple as making a choice from a menu. Getting R:BASE on your LAN is as economical as it is easy, five user add-on license packs are available.

R:BASE continues to grow with your business and your business needs. You'll find R:BASE has the powerful tool set you need to maintain and use your data. If you are writing a database application or maintaining a database, R:BASE is the tool to have, now, more than ever.

General

R> Prompt

RBDefine

Object Manager

Data Editor

Forms / Reports / Label Designer

RBEdit

Trace / Debug

Help File

Productivity Tools

Relational Features

  • Data dictionary
  • Full referential integrity with primary key, foreign key, and custom rules enforced at the engine level
  • Domain validation
  • Unlimited sort order
  • Unlimited column order
  • Index any column, any data type

Data Integrity

  • WRITECHK verifies every write to disk
  • SET MIRROR maintains a duplicate copy of the database
  • ON CONNECT/PACK runs a command file before or after connecting to or packing a database
  • SET SCRATCH allows temporary files to be stored on a different drive
  • Optimized PACK command eliminates any possible drive space shortage which could cause the PACK to fail

Tables/Views/Columns/Rows

  • Create up to 16,000 tables or views
  • Create up to 16,000 columns
  • Create up to 400 columns (fields) per table or view
  • Maximum row (record) lengths of 4096 bytes

Data Types

  • INTEGER
  • TEXT (up to 1500 characters, length must be specified)
  • DATE
  • NOTE (up to 4092 characters, specified length optional)
  • REAL
  • NUMERIC (fixed precision)
  • DOUBLE
  • CURRENCY
  • TIME
  • DATETIME
  • BIT, BIT(n), BITNOTE, VARBIT(n), and BIT VARYING(n)
  • VARCHAR(n), CHAR, AND CHAR VARYING (maximum size 255 MB)
  • LONG VARCHAR, LONG VARBINARY, and LONG VARBIT (maximum size 255 MB)

Query Capabilities

  • Create full, left, and right outer joins
  • Join up to ten tables using QBE facility, or an unlimited number of tables at the R:BASE command line prompt
  • Search to locate specific data in a result set quickly with QBE or the R:BASE R> Prompt
  • Dynamic single- and multi-column sorts while not affecting other concurrent network users
  • Save query results to a new table or as a dynamic view
  • Intelligent query optimizer for quicker response time

Multi-User

  • Allow multiple users to access the same table and row of data at the same time with optimistic concurrency control
  • Resolve conflicts quickly with automatic multi-user row-level and page locking
  • Create faster network throughput with optional locking settings
  • Perform database maintenance on network databases without going off-line.
  • Number of concurrent users does not affect performance

Forms

  • Display any form in a sizable window
  • Create an unlimited number of forms per database or table
  • Create a form with up to five tables or views
  • Sort, modify, or select data in forms on the fly
  • Retrieve data from any table using lookups
  • Manipulate information as it is added or edited using expressions
  • Embed event driven programs at the field, record, and table levels with EEPs (entry/exit procedures)
  • Call any form from within any form using EEPs
  • Embed multi-column popups using selected data from another table
  • Display multiple forms on the screen at one time, each in its own scalable window
  • Use the image of your choice to call a specified EEP or predefined action when the user clicks on that image

Reports

  • Create an unlimited number of reports per database or table
  • Base reports on multi-table views
  • Retrieve data from any table using lookups
  • Evaluate expressions at any defined report level
  • Automate totals, subtotals, and grand totals (aggregate functions)
  • Sort or select data in reports on the fly
  • Call a stored procedure inside a reports using an expression to create flexible and dynamic reports

SQL Support

  • 1989 ANSI Level II SQL
  • Partial 1992 ANSI Level II SQL

Labels

  • Create an unlimited number of label definitions per database or table
  • Customize label dimensions or select from label templates

Programming

  • Encrypt your program code for distribution and protection with R:BASE Codelock
  • View live data using a variety of commands and utilities
  • Full password security
  • Autofix for automatically fixing broken pointers
  • Full command line access at the R> prompt
  • Over 100 SuperMath functions
  • Output data from your database to a Web page in HTML table format
  • Create your own functions for any applicable event by using stored procedures
  • Your application can automatically call a specified stored procedure whenever an INSERT, UPDATE or DELETE event occurs.

Import/Export

  • Access and share dBASE data (and dBASE indexes) directly without importing or programming
  • Import/export the following file formats: dBASE versions 2-4 (DBF), Lotus (WK1, WK3, WK4, WKS), Excel versions 2-5 (XLS), Quattro (WKQ), Symphony (WR1 & WRK), ASCII delimited (comma or tab), Data Interchange Format (DIF), and Symbolic Link File Format (SLK)
  • Load ASCII delimited or fixed data directly from command line
  • Gateway (Import/Export) UI enhancements to show import/export progress such as disk space required, feedback on row counts, time to import/export

ODBC

  • Access R:BASE data from other R:BASE databases through the R:BASE ODBC driver, which is included
  • Access other ODBC-compliant databases such as Oracle and Paradox through their native ODBC drivers.
  • LOB (picture formats like .TIF, .BMP, .PCX, and .GIF) data types can be accessed from other R:BASE and ODBC compliant databases
  • Access Stored Procedures via ODBC

Runtime

  • Runtime executes a custom application you create by using R:BASE 4GL, a powerful programming language featured in the base product
  • Network unlimited runtime available for cost effective distribution
  • Runtime licenses available for an unlimited multiple-application distribution.

System Requirements

  • MS-DOS version 6.2 or higher (for DOS R:BASE)
  • Windows 95, Windows 98, Windows NT 4.0 and higher, Windows ME, Windows 2000, or Windows XP
  • Minimum 16 MB memory (32 MB or more is recommended)
  • Minimum 20 MB hard disk space to install required files; 25 MB to install all files.
  • Your particular disk space requirements will vary based on the size of your database
  • Mouse: IBM, Microsoft, or compatible mouse (optional)
  • Network: any NETBIOS compatible network protocol; peer-to-peer networks supported with dedicated/designated file server

Other Features

  • The AUTOUPGRADE Setting - SET AUTOUPGRADE ON and then connect to your 6.0 database. Having AUTOUPGRADE on will automatically convert the 6.0 database to a current version database and add the new system tables that handle the stored procedures.
  • Full Compatibility with OTERRO - The Oterro Database Engine gives the Visual Basic developer client/server features like SQL, multiple-users, and the ability to handle large-sized databases, but priced well below any client/server solution. ODBC Level 2 and higher compliancy.

Indexes

  • Create up to 16,000 indexes per database
  • Index any data type, even computed columns
  • Multi-column indexes

Productivity Tools

R:BASE 2000 now includes a premier set of productivity enhancing tools. Now included with R:BASE are the following: R:CODE 2000, which allows you to edit your command files and syntax at the same time in a high level graphical environment; R:STYLE 2000, which allows you to style your code for maximum readability; and finally, R:STRUC 2000, which gives you the ability to create a hyperlinked set of HTML pages which completely document your database's internal structure, including tables, columns, views and the links between them.