Re: [For forms GURU] Forms Crashing after schema change
Date: 1998/03/06
Message-ID: <01bd48fd$f504cc20$b43007cb_at_0000907l.itwol.bhp.com.au>#1/1
Yes, I have found a similar problem - you have the fix - recompile with
compile_all ON.
Try to develop a method of automating the recompiles.
As we werent using libraries as extensively as you, we didnt have as many
problems - I principally found that when I aded to a constants package
inside a library (.PLL) I needed to recompile.
I felt that this was because the binary was somehow being indexed to look
at particular addresses in the module, but that these addresses were
changing when the code was changed.
Hang on - doesn 4.5.7 allow compilation of libraries (its been a while
since I used Forms)?
I beleive that this is a feature that will fix this problem. If you
recompile your librbrary post-change into a (from-memory) .PLX, then you
may not have these problems
HIH
Lee Levy
Don't spam me!
tim_at_van.oz.au wrote in article <6dft1o$vsc$1_at_nnrp1.dejanews.com>...
...
> I have many forms that is not base on any tables. They all attached to
the
> a PLL library file. This PLL is the interface beween the forms and
> the server database. It actually call the PL/SQL stored procs in the
> server to perform query, update , insert etc.. All going very well except
> when there are some changes in the database design. Something like
> the structure of the tables change, rename a column name, alter a column
> size etc , the usual stuff in development cycle. All the stored-procs are
> of course update as well to reflect the changes but the interface
(package
> specs) are not change so there is no need to modify forms or the PLL
file.
>
> Now if I rerun those forms on the update database, chances are that 9 out
> 10 I'll get a GPF. Run the forms on the database with nochange at all is
> OK. The only way is to recompile the PLL library, then recompile (with
the
> option compile_all) the FMB files then generate FMX. Then the problem
will
> go away (ie. No GPF).
>
> Server : SCO OSD 5
> DB version 7.3
> Client: Windows 95
> Forms designer version 4.5.7.11
...
Received on Fri Mar 06 1998 - 00:00:00 CET