Larry: As a matter of personal practice, I normally prefer not to mess with system tables unless I absolutely have to do it. In any case, if you have two identical rows for the same form in sys_forms3 how do you determine which one you want to delete? Having a unique key on sys_forms3 will prevent you from loading a second form with the same name but you will still have to go and delete the form before you can load the updated one. Having the DROP FORM command in the form file does away with this problem...just my 2 cents... 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 Lawrence Lustig Sent: Tuesday, September 07, 2004 8:31 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Saving data to a form. > 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 Javier: In "modern" versions of R:Base, if you do wind up with a duplicate form, you can simply EDIT the sys_forms2 or sys_forms3 table and use F9 to delete the row. How about a unique key on the sys_form_name column, which would prevent duplicate forms from getting installed in a database? -- Larry
