Claudine, did this occur after a backup? ie, was there a routine that unloaded the database and reloaded the database.
Gary ________________________________ From: Claudine Robbins <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, May 4, 2010 10:47:16 AM Subject: [RBASE-L] - V8 Disappearing Form Table/View Connections I am hoping that someone has experienced this and can shed some light on why this has happened and maybe how to resolve it. This is the second time this has happened to me. Both times, I recovered the database forms (listing) by restoring a previous backup. Out of the blue, in R:BASE Explorer, Forms tab, the form names are listed but the Table/View and Form Description columns are blank. When starting the database, an error message warns the user that the main form cannot be loaded. Same error when I try to DESIGN the form. The form is based on FormTable which exists and has only one row. An UNLOAD ALL backup yields a very small file 35 K and no LOB! Upon close inspection, the SYS_FORMS3 has all the forms with their respective table/view, a description and the LOB data INTACT. Thinking that I could UNLOAD the sys_forms3 data, delete the sys_forms3 table and reload it from the backup, this is what I did and the resulting errors. SET NULL -0- OUTPUT SYSFORMS3.DTA UNLOAD ALL FROM SYS_FORMS3 OUT SCREEN RUN SYSFORMS3.DTA -ERROR- You cannot delete a system table. ( 10) -ERROR- Duplicate database name ( 720) Database Exists -ERROR- Illegal table name - SYS_FORMS3 (2037) Begin R:BASE Data Loading for SYS_FORMS3 End R:BASE Data Loading Even with the errors, I ended up with TWO ROWS for each form, clearly visible in the R:BASE Explorer | Forms tab. DELETE DUPLICATES FROM SYS_FORMS3 USING SYS_FORM_NAME 136 row(s) have been deleted from SYS_FORMS3 I am returned to a Forms List with no Table/View or Form Description in R:BASE Explorer. TIA, Claudine
