Wednesday, September 19, 2007
Tip of the Day: Converting 6.5++ Database to Turbo V-8
The TURBO command in R:BASE Turbo V-8 is intended to UPGRADE
your existing R:BASE 7.x database to Turbo V-8, including all
R:BASE 7.x Forms, Labels, Layouts and Reports.
However, if you need to jump directly from 6.5++ for Windows
to R:BASE Turbo V-8 for Windows, you may use the alternative
method of building an R:BASE Turbo V-8 database using the
file structure and data from R:BASE 6.5++ for Windows using
the traditional UNLOAD ALL command.
Here' how:
01. Start R:BASE 6.5++ for Windows and CONNECT dbname
02. Check the IDQUOTE settings of connected database:
At the R> Prompt:
SHOW CHARACTERS
Notice the last parameter, IDQUOTES
If IDQUOTES is set to NULL, you'll need to change NULL
to the appropriate character, such as ` (reversed quote)
as following:
SET IDQUOTES=`
03. Unload the entire database:
At the R> Prompt:
SET NULL -0-
OUTPUT filename.ALL
UNLOAD ALL
OUTPUT SCREEN
This process will create two files (filename.ALL and
filename.LOB)
04. Disconnect the database:
At the R> Prompt:
DISCONNECT
05. Now Start R:BASE Turbo V-8 (C:\RBTI\RBG8\RBG8.exe)
Switch the default directory to the folder with
filename.ALL and filename.LOB files.
At the R> prompt of R:BASE Turbo V-8:
RUN filename.ALL
This step will build a clean database to be used
exclusively by R:BASE V-8 Turbo.
New database files will have the following extensions:
dbname.RX1
dbname.RX2
dbname.RX3
dbname.RX4
X = eXtended
LIST DATABASE command at the R> prompt will only list
Tubo V-8 database(s) in that folder.
All R:BASE 6.5++ for Windows Forms, Reports, and Labels can
be converted to Turbo V-8 for Windows using the "Convert"
option from appropriate module of Database Explorer.
Once the database is converted, it can only be connected
using R:BASE V-8 Turbo.
Along with "NO 2GB LIMIT", more power and V-8 specific
commands, you also have the ability to use up to 128
characters naming convention for database, tables, columns,
etc.
Product Details: http://www.rbase.com/rbg8/
Product Comparison: http://www.rbase.com/products/compare.php
Very Best R:egards,
Razzak.
