In addition to changing the column definition in tables, you should also
search all your program code if you think there's any chance that you defined
a temp table using that column name/data type. If you use external
programs, use whatever utility you want to search all code for the existence of
that column name. If your code is embedded in forms, then do something like:
select all from sys_forms3 where #4 contains 'my column name'
Or if you're in 9.x you can use the built-in function to do the search
(can't remember where the option is off the top of my head).
Karen
In a message dated 1/23/2012 1:51:37 PM Central Standard Time,
[email protected] writes:
> I need to update a number of columns in several tables from REAL to
> DOUBLE.
> Of course I would like this to go as smooth as possible so I hope several
> forms and reports don't blow up.
> And these columns share the same names across tables.
>
> Any suggestions before I write my change file?
>
