Karen, Like your idea of directly editing the code in sys_form3 table. One caveat, data must be stored uncompressed. Would't it be nice in V9.? if there was an option in RBedit or RBBEdit to have decompress the form for edit. Also, I am looking forward to the public release of the detail description of the structure of the form/report/label code. In the DOS days I had a complete documentation of the SYS_REPORT/SYS_FORM/SYS_LABEL code and was not above going in and fixing/adjusting the code. It was great to be able to do and EDIT #2 IN SYS_FORMS WHERE #1='formname' I could then do a fix to column location/size without calling up each form. This was handy since I had separate forms for EDIT, ADD, DELETE, and INQUIRY.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ________________________________ From: "[email protected]" <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, April 28, 2009 9:00:25 AM Subject: [RBASE-L] - Re: Report will not open Tom: Glad my suggestion prompted your solution! But I just tried something else here. I created a temp table, created a form based on it, and in the "on before design eep", I dropped the temp table then put the temp table definition in there. Saved the form. Then I went into the "on before design" and purposely made a change to the table definition that would make the table not work (left off a datatype). Tried to bring up the form and of course it wouldn't come up. I did an "edit all from sys_forms3", edited sys_data and easily found the code at the beginning. Changed the code to make it correct, saved it, and now the form comes up. So in your case you didn't need to bother adding in the old names; you could have gone into sys_forms3 and just modify the code. Karen Razzak and Karen, You got me on the right path. Went to an older working copy of the report from 3 months ago. Looked at the old view and the current problem view. I had changed one letter in three column names to stay more consistent with a naming system that just developed. Makes much easier reading to me. The name changes were great for other reports, except I forgot to adjust this one report, so I basically adapted Karen's idea. Inserted the old names into the current table and up pops the trouble report in designer. Changed the report fields to the correct names, moved the data to the new columns, deleted the trouble columns, and it now runs like it should. Took maybe 30 minutes. The other reports all work. Than you for the brain kick. Tom Frederick
