R:azzak: When in the R:Base Explorer and you right click on a form (say my_form) or report name and select "Unload..." it creates a file with extension FRM such as my_form.RPT plus a file with extension LOB. It would be really nice if the code in the file my_form.FRM would include the line: DROP FORM my_form Or DROP REPORT my_report This would prevent the accidentally loading of a second version of the form (it happens) or report and then you end up with two versions of the same form with the same name but when you try to delete one, it deletes both...I know that good programming practice requires that you drop the form first, but many time when doing development and moving forms and/or reports between test and production databases, it is done from the Explorer rather than from code and it is not uncommon to load a second version of the form or report... Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak Memon Sent: Monday, September 06, 2004 10:20 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Saving data to a form. Benjamin, FYI, following system tables are related to R:BASE 7.x for Windows: SYS_FORMS3 -- Forms SYS_LABELS3 -- Labels SYS_LAYOUTS3 -- Custom Layouts when LAYOUT is ON) SYS_MERGE -- For R:Merge Templates (also in 6.5++) SYS_REPORTS3 -- Reports In your case you'll need the following syntax: CONNECT OldDB SET NULL -0- OUTPUT TempForm.DAT UNLOAD DATA FOR SYS_FORMS3 WHERE SYS_FORM_NAME = 'OldForm' OUTPUT SCREEN -- That will create two files (TempForm.DAT & TempForm.LOB) CONNECT NewDB SET NULL -0- DROP FORM OldForm INPUT TempForm.DAT To UNLOAD the form, you may also use the Database Explorer. Here's how: Database Explorer | Forms | Highlight the form and use right-click for Speed Menu options and select Unload... That's all there is to it! Have fun! Very Best R:egards, Razzak. At 11:02 AM 9/6/2004 -0400, Benjamin Strickland wrote: >Is the code below the correct code for saving a form? > >My problem is the output file is giving me blank data. > >CONNECT olddb >SET NULL -0- >OUTPUT tempform.dat >BACKUP DATA FOR SYS_FORMS2 WHERE SYS_FORM_NAME = 'oldform' >OUTPUT SCREEN >CONNECT newdb >SET NULL -0- >RUN tempform.dat
