Re: system variables in oracle forms

"marc" <nekoliko_1_at_yahoo.com> schrieb im Newsbeitrag news:bgqpb1$7pp$1_at_sunce.iskon.hr...
> Hi everyone,
> could anyone explain to me is there any similarity between
> :system.form_status and :system.mode variables in oracle forms. i'm a
little
> bit confused when to use the first and when the other one.
> thx
> marc
>
Hi Marc, both variables serve different purposes and have nothing to do with each other:

Values of :SYSTEM.MODE:

'NORMAL' = "normal processing mode" for entering or changing records
'ENTER-QUERY' = "Enter Query mode" for QBE (query by example)
'QUERY' = Query is being executed right now, please wait

Values of :SYSTEM.FORM_STATUS:

'CHANGED' = at least 1 changed record is in the Form
'NEW' = only new records in the Form
'QUERY' = only queried records in the Form

(My info goes only to Forms Version 6i btw ...)

hth, Jan Received on Mon Aug 11 2003 - 11:45:13 CEST