[RBG7-L] - RE: Saving data to a form.

[A. Razzak Memon]

Benjamin,

FYI, following system tables are related to R:BASE 7.x
for Windows:

SYS_FORMS3      -- Forms
SYS_LABELS3     -- Labels
SYS_LAYOUTS3    -- Custom Layouts when LAYOUT is ON)
SYS_MERGE       -- For R:Merge Templates (also in 6.5++)
SYS_REPORTS3    -- Reports

In your case you'll need the following syntax:

CONNECT OldDB
SET NULL -0-
OUTPUT TempForm.DAT
UNLOAD DATA FOR SYS_FORMS3 WHERE SYS_FORM_NAME = 'OldForm'
OUTPUT SCREEN

-- That will create two files (TempForm.DAT & TempForm.LOB)

CONNECT NewDB
SET NULL -0-
DROP FORM OldForm
INPUT TempForm.DAT

To UNLOAD the form, you may also use the Database Explorer.

Here's how:

Database Explorer | Forms | Highlight the form and use
right-click for Speed Menu options and select Unload...

That's all there is to it!

Have fun!

Very Best R:egards,

Razzak.

At 11:02 AM 9/6/2004 -0400, Benjamin Strickland wrote:

Is the code below the correct code for saving a form?

My problem is the output file is giving me blank data.

CONNECT olddb
SET NULL -0-
OUTPUT tempform.dat
BACKUP DATA FOR SYS_FORMS2 WHERE SYS_FORM_NAME = 'oldform'
OUTPUT SCREEN
CONNECT newdb
SET NULL -0-
RUN tempform.dat