Re: Forms 4.5 - Memory Problem

Steve, thanks for the reply.

I do have a base table block but I am not using the Last_Record comand.

The block has 2 triggers ...

PRE-QUERY:
:cr_totals.current_risk_total := 0;

POST_QUERY:
SELECT MIN(cr_risk.current_risk) INTO :cr_main.current_risk

   FROM cr_risk
   WHERE cr_risk.change_ref = :cr_main.change_ref    AND cr_risk.system = :cr_main.system;

IF :cr_main.current_risk IS NOT NULL THEN

   :cr_totals.current_risk_total := :cr_totals.current_risk_total + :cr_main.current_risk;
END IF; Any further ideas?
Paul.

I have 2 triggers in the bloc
Steve Cosner <stevec_at_zimmer.csufresno.edu> wrote in message news:IrQI3.84$dB1.6590_at_nntp.csufresno.edu...
> Do you have a base-table block where your form is doing a Last_Record
> command? If there are lots of rows, this has been a problem with Forms.
>
> Steve Cosner
>
>
> In article <7t0irk$48g$1_at_plutonium.btinternet.com>,
> Paul Hancock <freddie_at_hotmail.com> wrote:
> >One of the forms seems to be EXTREMELY memory hungry when it runs. I've
ran
> >it it on a number of PC's and all are pretty beefy (128MB of RAM). The
form
> >is not particularly big or complex, certainly no bigger than the other 3
I
> >have developed.
> >
> >It refuses to run if I have any more than 2 other applications open (eg.
> >WORD, FORMS DESIGNER). When running it gets so for into displaying the
gui
> >when it stops and displays a message "cannot display item {item name}".
If I
> >then quit WORD say, and re-run it (without re-booting) it runs fine.
Received on Thu Sep 30 1999 - 16:31:34 CDT