Except it won't work on Reports...
----- Original Message -----
From: <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, April 28, 2009 10:00 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
