787.TXT ===================================================================== The Best 32-bit SQL Database Engine for Your WindowsTM Applications ===================================================================== PRODUCT: SQL Engine VERSION: 2.0 ===================================================================== CATALOG: PROGRAMMING IN R:BASE AREA : SQL ===================================================================== Microrim has just released a new version of the R:BASE SQL Engine, version 2.0 for Windows. If you need to develop Windows applications, then you need version 2.0 of the R:BASE SQL Engine. With Version 2.0, you can use any Windows application development environment that supports ODBC Level 1, such as Visual Basic or C++, to build royalty-free independent applications with the back-end power and flexibility of R:BASE. This new release includes the following new features: 32-bit engine. The R:BASE SQL Engine 2.0 is one of the few 32-bit database SQL engines available today. It takes advantage of the power and functionality of the 32-bit environment using Microsoft's WIN32s to create 32-bit Windows applications. New documentation and on-line help. Version 2.0 includes an updated User's Manual and Windows on line help. These new features are a definite improvement over the last release of the R:BASE SQL Engine. New samples. This updated package also includes new sample applications in both the Visual Basic and C++ languages. These samples are referenced throughout the documentation and on line help as examples of how to use version 2.0 with the more popular Windows development environments. You may also cut & paste sample code referenced in on line help, and use it within your own application code. ODBC level 1. Version 2.0 of the R:BASE SQL Engine is ODBC level 1 and partial level 2 compliant. This means you can use any Windows tools and/or data controls that support the ODBC level 1 standard. This allows you, as an R:BASE developer of Windows applications, more efficient programming options. Added R:BASE features. This updated release also has added R:BASE database optimization features, including: PACK & RELOAD, Variables, UDFs, STATICDB, FASTFK, and over 70 Super Math functions. As a developer, you can take advantage of some of R:BASE's key development tools within your Windows applications. ANSI '89 Level 2 SQL. Version 2.0 complies with full ANSI '89 Level 2 SQL with SQL '92 extensions, including: Data Definition Language (DDL), Data Manipulation Language (DML), updatable bi-directional scrollable cursors, row-level locking, built-in declarative referential and entity integrity, and multiple simultaneous database and/or application connections. All the functionality of last release and more. R:BASE SQL Engine 2.0 continues to provide you with the ability to manipulate databases, associated tables, views, and dBASE files, while maintaining the same level of support for security and data integrity as found in the full R:BASE product. Version 2.0 includes all the same functionality R:BASE SQL Engine has always provided, including: royalty-free runtime, local area network (LAN) unlimited user support, cost-based query optimization, complete indexing capabilities, SQL and ODBC standard error handling, dBASE support, and more. Database specifications Numerous data types are supported, including: CHARACTER, CURRENCY, DATE, DATETIME, DECIMAL, DOUBLE, FLOAT, INTEGER, NOTE, NUMERIC (fixed precision), REAL, SMALLINT, TEXT, and TIME Unlimited rows (records) per table and database Unlimited tables per view Up to 16,000 indexes per table or database Up to 16,000 columns (fields) Up to 16,000 tables and views Up to 400 columns (fields) allowed per table 4,096 is the maximum row (record) length Characters per column (field) are limited to 4,092 for note data and 1,500 for text data Maximum data file size is 4 Gigabytes System Requirements A PC with a 386 or faster processor with a minimum of 4 MB of RAM (8 MB r ecommended) Microsoft Windows 3.1 or above The R:BASE SQL Engine requires approximately 4 MB of hard disk space; C++ compilers, Windows programming environments, databases and applications require additional space; refer to each product's documentation for information about additional memory requirements A Windows application programming environment, such as: Microsoft C 6 / C 7, Visual C++, Microsoft Visual Basic 2.0 or above, Borland C++ languages, or other Windows programming languages that can call DLLs (for example, PowerBuilder) Networked: requires a NetBIOS compatible dedicated server Order Today! The suggested retail price of version 2.0 is $595. If you are already a registered user of the R:BASE SQL Engine, you are eligible to receive version 2.0 for the special upgrade price of $195. To purchase this product or request more detailed information, call the Microrim Sales Department at 800/628-6990. R:BASE is a registered trademark of Microrim, Inc. Windows 3.1, ODBC, Microsoft C, WIN32s, Microsoft Visual Basic, and Visual C++ are registered trademarks of Microsoft Corporation. Borland C++ and dBASE are registered trademarks of Borland International. PowerBuilder is a trademark of Powersoft Corporation.