Faith,
This was originally my baby, based on a lot of discussion on this list, and
the "on close designer" eep that had first appeared at that time. I haven't
used that utility in a long time, so bear with me a bit. There were two
categories of ways to back up forms (and reports and labels). One was to *keep
the older copies of those objects in a table in the database.* The other was
to generate in batch (or singly), file pairs (e.g. .FRM and .LOB) that *saved
archives outside of the database.*

In the first method, the archives -- older saved copies of forms -- were
actually saved in a table named FRL_Revisions, (not FRL_SYS_Table).
vFRL_SYS_TABLE is a variable in the programs, that will hold the name of one
of the real system tables, like SYS_FORMS3, in which there is one and only
one version of each form. For that to work, you had to have placed a
specific command in the "on close designer" eep of every form, report, or
label that you wanted to back up, (for example, RUN FRL_onDesignerClose.eep
USING 'FORM', .RBTI_FORM_FORMNAME) and you had to keep a particular command
file in the database folder (FRL_onDesignerClose.eep).

Does your database have a form installed in it named "FRL_Console?" If so,
try EDIT USING FRL_CONSOLE.

If you have used the EEPS in forms, then each saved version of the form
would be stored in the FRL_SYS_DATA table, and saved versions will show up
in the list view at the bottom when you click on the current form name in
the top list view.

Click on the Forms radio button, then click on the name of the form that you
would like to restore in the upper box. Then click on the revision you want
to restore. The "Restore" button should become active. When you click the
"Restore" button, you will be prompted to confirm that you want to overwrite
the current copy of the form with the backup from a particular time and
date. The on-click EEP for that button ends with a command like this:

  INSERT INTO &vFRL_Sys_Table +
    SELECT +
        FRL_Obj_Name,FRL_Sys_Table,FRL_SYS_Comment,FRL_Sys_Data,+
        FRL_Sys_Tables_Def +
      FROM FRL_Revisions +
      WHERE FRL_RevisionID = .vCFRL_Obj_ID

vFRL_SYS_Table would have had the value SYS_FORMS3, and vCFRL_Obj_ID would
have held the Primary Key value of that particular archive in the
FRL_Revisions table.

In the second method, you needed only to find the file pair in a subfolder,
and RUN The .FRM/.RPT/.LBL file.

Let us know if this helps
Bill

On Mon, Jun 29, 2009 at 9:47 AM, Faith <[email protected]> wrote:

>  Hello Folks,
> We are testing this rbasecommunity appplication to track form revisions and
> are trying to determine how to use the BLOB columns
> FRL_Sys_Data and FRL_Sys_Tables_Def in the FRL_Revisions table to actually
> restore a form to it's previous state (from an archived change record).  The
> included documentation is mute on how to restore an item (at least we
> could not find the instructions for how to restore in the doc.)  We tried to
> use the "Save to External File" option by right clicking on the desired
> FRL_Sys_Data (BLOB) column value and saving it to a .frm file.  Restoring
> this by using the Form Load command and pointing to this file to load does
> not seem to do anything.
> Is this documented and if not how do you restore from an FRL_Revisions
> record?
> thanks,
> Faith Wilde
>
> 013. Keeping Track of Form, Label and Report Revisions
> Author: Bill Downall 05/23/2006
>
>
> http://www.rbasecommunity.com/
>

Reply via email to