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/

