Thanks so much Bill, that was a really great help.  

________________________________

From: [email protected] [mailto:[email protected]] On Behalf Of Bill
Downall
Sent: Monday, June 29, 2009 10:33 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: FRL_Revisions rbasecommunity application - how
to restore from an FRL_Revisions record?


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