At 04:12 PM 7/17/2001 -0600, Farnsworth Midge D Contr wrote:
>Using R:base 6.1a is it possible to merge forms from
>two different databases into one database? Both databases
>contain the same tables that the forms are based on.
Follow these steps to accomplish your task:
I'm assuming you're using R:BASE 6.1a for Windows!
To Copy/Replace ALL Forms:
01. CONNECT RBDBMS1
02. SET NULL -0-
03. OUTP Forms.FRM
UNLOAD DATA FOR SYS_FORMS2
OUTP SCREEN
This step will create two files:
. Forms.FRM
. Forms.LOB
04. Copy both files to the other directory where
RBDBMS2 resides
05. Change directory where other RBDBMS2 resides
06. CONNECT RBDBMS2
07. SET NULL -0-
08. DELETE ROWS FROM SYS_FORMS2
09. INPUT Forms.FRM
There you have it ...
To Copy/Replace Any Given Form(s):
01. CONNECT RBDBMS1
02. SET NULL -0-
03. OUTP Forms.FRM
UNLOAD DATA FOR SYS_FORMS2 WHERE +
SYS_FORM_NAME = 'FormName'
OUTP SCREEN
OR
OUTP Forms.FRM
UNLOAD DATA FOR SYS_FORMS2 WHERE +
SYS_FORM_NAME IN (FormName1, FormName2, ...)
OUTP SCREEN
This step will create two files:
. Forms.FRM
. Forms.LOB
04. Copy both files to the other directory where
RBDBMS2 resides
05. Change directory where other RBDBMS2 resides
06. CONNECT RBDBMS2
07. SET NULL -0-
08. DELETE ROWS FROM SYS_FORMS2 WHERE +
SYS_FORM_NAME = 'FormName'
OR
DELETE ROWS FROM SYS_FORMS2 WHERE +
SYS_FORM_NAME IN 'FormName1, FormName2, ...'
09. INPUT Forms.FRM
Last but not least, you could ALSO use R:BASE ODBC
method to achieve the same goal!
Enjoy and make sure to have fun!
Very Best Regards,
Razzak.
===================================-============================
R:BASE Developers's Conference: http://www.rbase.com/conference
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
