Re: Two Forms4.5 questions

[Quoted] "Jens Lechtenboerger" <Jens.Lechtenboerger_at_Informatik.Uni-Oldenburg.DE> wrote:
>Hi there,
>
>I have two questions concerning Forms 4.5:
>
>1. I am using a block consisting of database items, all of them having default
>values. How do i force Forms to insert the resulting record when an operator
>presses a commit-button without first changing an item?
>Right now Forms raises the message "No changes to commit".
>
>2. I am using lost of LOVs and I am in doubt if each of them opens a cursor
>without closing it later. After showing about 15 LOVs or so, the maximum number
>of open cursors is reached and subsequent actions raise an error message.
>Is there a possibility to examine how many cursors are opened at a time?
>Can I force Forms to close the cursors?
>
>Thanks,
>

Hi there,

[Quoted] For the first question, try using set_record_property to 'NEW' or 'INSERT'. This will force forms to insert that record.

[Quoted] For the second question, set AUTO_REFRESH property to FALSE. This will caue only one select statement issued and subsequent times it will use the memory.

I think the above solutions will help you to solve your problem

Good Luck

N.Prabhakar Received on Mon Dec 02 1996 - 00:00:00 CET