system.mode&syste.form_status

[ninoslav]

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.
Some practical examples are welcome
thx

 

[sem]

You may check their allowed values in online help.
FORM_STATUS agregates block statuses: If none of them contains records - it's NEW, if at least 1 is changed - it's CHANGED, otherwise - it's QUERY.
MODE defines current operation. When you're entering query criterium, it's ENTER-QUERY, when the query is being executed, it's QUERY. Otherwise (entering/viewing data) - it'sNORMAL.

Regards, Dima

 

[ninoslav]

Hi Sem,
thx for your post. However, i new these facts you have written. The thing i was interesting was similarity between this variables. For example:
if the form is retrieving date from the database, it has system mode QUERY. At the same time it's :system.form_status value is QUERY.
I was looking on oracle site and in manuals for some tabular connectin between these variables.
For example: (sth like this)

form_status mode :system.record_status
enter f QUERY NORMAL NEW
F7 QUERY ENTER-QUERY NEW
F8 QUERY NORMAL QUERY
F6 QUERY NORMAL NEW

Do you have sth like this with more details for the whole form processing?
regards

 

[ninoslav]

Hi,
i have made some mistake in my post (if the form is retrieving date from the database, it has system mode QUERY.....it should me NORMAL), but it was written corect in the table.

 

[sem]

I suppose that you're confused by the same value allowed for different entities. Though 90 degree is not always a right angle. Sometimes it's a very hot water

Regards, Dima

 

[ninoslav]

Hi Dima,
i like that example with 90 degrees .
Could you tell me have you ever (and in which situation) checked system.mode = 'QUERY' status? It seems to me that status is pretty behind the scene. For example, when you press F7, system.mode is 'ENTER-QUERY', and after F8 it is 'NORMAL'.
regards
n.

 

[sem]

Check :system.mode in post-query trigger, it's 'QUERY'. In some cases you may need to call the same procedure in different situations, e.g. in POST-QUERY and WHEN-NEW-RECORD-INSTANCE, and know from within how it was invoked.

Regards, Dima