David:
What I normally do is go to Forms in the R:Base Explorer, right click on the form you want to download and select "Unload Form." You will be prompted for a location where to store the file, which by default has the name of the form with the extension ".frm" The system will also create a second file with the same name and the extension ".lob" You need to include both, the xxx.frm and xxx.lob when you want to load the form in a different database. You will notice that the first line of the .frm file includes the statement "Drop Form xxx" so you no longer have to do it before loading the new version of the form; The procedure is the same for reports and views. Since the users work with a current copy of the form, you can update forms (views and reports as well) in a live database and the next time a user opens the form after the update, the new version will be displayed. If you just want to use code, the commands would be: OUTPUT FormName.FRM UNLOAD DATA FOR SYS_FORMS3 WHERE SYS_FORM_NAME = 'FormName' OUT SCREEN Please note that 2 files will be created FormName.FRM and FromName.LOB Then on the client side, you only need to run: RUN FormName.FRM I hope this info is of help. Javier, Javier Valencia 913-915-3137 _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David Blocker Sent: Monday, September 22, 2008 2:50 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Backup External Form? Dear R:Base friends - I also posted this question a week ago. It's possible someone sent me an answer but I never received it - for some reason I received no messages from the list for 2 days thereafter and then as mysteriously as it stopped, deliveries started again. So here it it again: I know that when you want to replace one version of a normal form with another, you need to: OUTPUT FormName.FRM UNLOAD DATA FOR SYS_FORMS3 WHERE #1 = 'FormName' OUT SCREEN Then on the client side, you must DROP FORM FormName RUN FormName.FRM With an external form file, am I correct that all you need to do is send the FormName.RFF file R:Base creates and have it overwrite the existing file? David Blocker David Blocker [EMAIL PROTECTED] Telephone: 781-344-1920 Cell Phone: 339-206-0261
