Jeff,
Remember .. No question is kind of a dumb question!
Here's what I suggest:
If you are the ONLY one controlling the updates
and additions, then:
On your master database:
CONNect DbName
SET NULL -0-
OUTP Forms.FRM
UNLOAD DATA FOR Sys_Forms2 ORDER BY Sys_Form_Name
OUTP SCREEN
That command will create two file, i.e:
Forms.FRM
Forms.LOB
Using the RBEdit or RCODE, edit the Forms.FRM file
and add the following one line at the beginning:
DELETE ROWS FROM Sys_Forms2
Save the file.
Now transfer those two files (Forms.FRM, Forms.LOB)
to customer/remote site.
At the customer/remote site:
CONNECT DbName
SET NULL -0-
INPUT Forms.FRM
To do the same for Sys_Reports2 ...
OUTP Reports.RPT
UNLOAD DATA FOR Sys_Reports2 ORDER BY Sys_Report_Name
OUTP SCREEN
That command will create two file, i.e:
Reports.RPT
Reports.LOB
You can see that Sys_Forms2 data files are different
than the Sys_Reports2 data files.
There you have it ... Gabba Gabba Hey!
Before updating the remote database, make sure that
there is no one using the database, especially any
forms.
To automate this entire process, you may want yo use
the (CVAL('Connections')) to make sure that there is
only ONE connection, i.e, you.
Have Fun!
Very Best Regards,
Razzak.
At 04:11 PM 4/21/2001 -0500, Jeff Ward wrote:
>This is kind of a dumb question, but can you replace the entire sys_forms2
>table in windows by unloading data from a newer sys_forms2, deleting the
>data at a client site and loading in another file. When you unload the
>entire sys_forms2 table the .LOB file is created, but I ask this because I
>am not sure if deleting rows from sys_forms2 actually effects where the
>windows reports data is stored?
===================================-============================
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.
==================================-=============================
