Geoffrey
As always make sure you have a copy of the database.
It appears you loaded all of the contents of your new file by using
LOAD SYS_FORMS3 from .....
If you didn't have any other forms in that new database then from the
R>DELETE ROWS FROM SYS_FORMS3 otherwise you will need to use the backup
copy of your new database.
To transfer forms from one 7.6 database to another A couple of
warnings
Make sure you delete the same forms from your new database.
Connect to Original database
R> SET NULL -0-
R> OUT MyForms.RPT
R> UNLOAD data for SYS_FORMS3
R> OUT TERM
You should have to files named MyForms.RPT and MyForms.LOB
Copy or Move these two files to the same folder as the new
database.
Connect to New Database
Make sure the forms you are going to load don't already exist in
the database.
R>SET NULL -0-
R>RUN MyForms.RPT
Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of Geoffrey
Wheeler
Sent: Saturday, March 07, 2009 5:03 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Copying a form to a different database
Just want to check to see if I did this correctly:
I needed to copy 2 converted DOS variable forms from one 7.6 database to
another.
I used
UNLOAD DATA FROM SYS_FORMS3
(it only had 2 forms in it)
I then used
LOAD SYS_FORMS3 FROM filespec
to load the forms to the other database.
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.
Voraciously vindicating volumes of variables in a village,
Geoffrey
Geoffrey
