At 05:02 AM 3/7/2009, Geoffrey Wheeler wrote:
I got 2 errors several times over:
- incorrect number of values for this table
- column SYS_DATA must be a valid VAR_BIT
Is there anything I missed in this procedure?
I noticed a .LOB file was created in the directory along
with my output file. The forms seem to have come through
OK. I need to check my application to see how I used them
to see if they're missing any functionality.
Geoffrey,
In addition to Buddy Walker's response earlier, the items
listed below might help understand the smooth transition
while converting and upgrading from DOS to Windows.
While copying/unloading the newly converted windows forms,
reports, and labels from one database to another, take
note of the following:
01. Make sure that the database CHARACTER SETtings are
identical between the two databases.
After CONNecting the database, SHOW CHAR at the R>
prompt will reveal all details.
Change IDQUOTES setting to ` (single reversed quote),
if blank.
SET IDQUOTES=`
02. If not done earlier, make sure that recipient database
has also gone through the recommended procedure of
converting/upgrading database.
SET AUTOUPGRADE ON
SET AUTOCONVERT ON
CONNECT dbname
This simple routine assures the creation of the following
SYStem tables required to manage windows Forms, Labels,
Layouts, Merge, and Reports.
The following SYStem tables are created, if not defined
already:
While converting from DOS to 6.5++ for Windows:
. SYS_FORMS2
-- to store converted DOS and new 6.5 win forms
. SYS_LABELS2
-- to store converted DOS and new 6.5 win labels
. SYS_MERGE
-- to store R:Merge for Windows templates
. SYS_REPORTS2
-- to store converted DOS and new 6.5 win reports
While converting from 6.5++ Win to 7.x for Windows:
. SYS_FORMS3
-- to store converted 6.5 win forms and new 7.x forms
. SYS_LABELS3
-- to store converted 6.5 win labels and new 7.x labels
. SYS_LAYOUTS3
-- to store Data Browser/Editor saved layouts when
clicking on "Save Layout" if LAYOUT is set to ON.
. SYS_REPORTS3
-- to store converted 6.5 win reports and new 7.x reports
03. Unloading any module with BLOB (VARBIT) data will
always create two files (filename.ext and filename.lob).
04. When unloading and loading modules to a different database,
make sure to copy/move both files, if the recipient DB is
in a different drive/folder.
05. If unloading/loading one table, view, stored procedure,
report, label, or form at a time, try the built-in "Unload"
option of Database Explorer when using the right-click
option of the respective speed menu.
06. Last but not least, while converting to 7.6 for Windows,
take a look at the following technical documents that cover
all topics and more, step-by-step.
From The Edge: http://www.razzak.com/fte/
Topic: Upgrading to R:BASE 7.6 for Windows
(Database Conversion Guide)
Related Documents:
. Database Maintenance (R:BASE 7.6 for Windows)
. Programming in R:BASE 7.6 and Turbo V-8 for Windows
. Gaining Speed with Programming in R:BASE
. Problem Solving in RBASE
. Command Index (R:BASE 7.6 for Windows)
. Function Index (R:BASE 7.6 for Windows)
. All About the CHOOSE Command
. All About the DIALOG Command
. All About the PRINT Command
Hope that helps!
Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
