Re: oracle forms 5 post problem

Thanks for your reply
I have found a workaround :
in the post-forms-commit trigger I put the following code : (fortunately the status is changed and only changes to QUERY after this trigger)

if :system.form_status = 'CHANGED' then

   :ctrlblock.sw_posted_notcommitted := '1'; end if;

in the post-database-commit trigger i put : :ctrlblock.sw_posted_notcommitted := '0';

works fine for me

"Neville Sweet" <sweet.neville.nj_at_bhp_xxx_.com.au> wrote:
>Marina,
>
>Once you Post, the Form knows internally that changes still need to be
>committed, but unfortunately Forms doesn't provide any way to test this
>status. The workaround is fairly simple - maintain your own variable. Set
>the variable whenever Post occurs, and reset it on commit.
>
>marina wrote in message <3b023280$0$43046$456d72a3_at_news.skynet.be>...
>>
>>Hi all,
>>
>>I have a multi-record block, in that block I do a Post command in the
>>when-new-record-instance so i can check whether a user has entered a record
>>which is identical to an existing one in the same grid.
 

>>since i have issued a post the status has become QUERY
>>question :
>>how can I know that their are still records to be committed, where does
>>forms store that info ?
 

>>any help would be appreciated
>
>
>
Received on Thu May 17 2001 - 12:28:48 CEST