OraFAQ Forum: Forms » block status

Home » Developer & Programmer » Forms » block status (Oracle Forms 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

block status [message #545242]

Tue, 28 February 2012 01:57

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

Is it possible to get the status of form or block every time? I mean if user presses Enter query key, it should display some status and if user presses execute query key then it should reflect some status. If user update any then it should reflect.

Report message to a moderator

Re: block status [message #545243 is a reply to message #545242]

Tue, 28 February 2012 01:59

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Utilize :SYSTEM.BLOCK_STATUS system variable.

Report message to a moderator

Re: block status [message #545246 is a reply to message #545243]

Tue, 28 February 2012 02:07

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

kindly tell me where to utilize this system variable? in which trigger?

Report message to a moderator

Re: block status [message #545265 is a reply to message #545246]

Tue, 28 February 2012 03:42

Maaher
Messages: 7065
Registered: December 2001

Senior Member

A little bit too vague what is "some status"? And what is your definition of "if user update"? Is it on commit? Or when a field's value is updated?

MHE

[Updated on: Tue, 28 February 2012 03:42]

Report message to a moderator

Re: block status [message #545372 is a reply to message #545265]

Tue, 28 February 2012 23:27

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

here term 'some status' means that the block is in 'NEW' or in 'CHANGED' or in 'QUERY' mode. As i was in search of global thing so that i can define in the library itself and save myself from modifying all the forms in the system. But, i think there is no way of doing this. You have to define in the triggers (block - level). I have used following triggers to see the block status at every moment.
POST-UPDATE Trigger
POST-QUERY Trigger
POST-CHANGE Trigger
PRE-RECORD Trigger

This may help those whom this is new. And I will appreciate if someone have some better idea than this ..

Report message to a moderator

Re: block status [message #545380 is a reply to message #545372]

Wed, 29 February 2012 00:03

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What is this "feature" used for? I mean, why does this information make your users happier than before you implemented it?
Your user

Whoa! A block is in CHANGED status now! How about yours?

Report message to a moderator

Re: block status [message #545386 is a reply to message #545380]

Wed, 29 February 2012 00:25

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

I took this thing non seriously first but I have to work on it after seeing users reactions. As I have some new users (dumb fellows) and they dont want to use some of their minds while dealing with forms. Despite of having some training, pressing every buttons to see its effect like kids. For example, they were entering the data in query mode and try to save this information. After doing this, a message like (NO Changes are made) came on screen. Then they dont take a minute to blame Oracle guys that the form is not working properly and such.

I did this to make my life easy on wards ... Smile

Report message to a moderator

Re: block status [message #545393 is a reply to message #545386]

Wed, 29 February 2012 00:46

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I think that you are far too optimistic (regarding these guys).

Report message to a moderator

Previous Topic:	Uniform Canvas/window size
Next Topic:	calling a form (merged 2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 04:45:10 CST 2025