Query_Only Mode [message #484453] |
Tue, 30 November 2010 12:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Kevin58
Messages: 79 Registered: January 2009
|
Member |
|
|
How can I programmatically tell if a form is opened in query only mode?
I've tried GET_BLOCK_PROPERTY(block_id, UPDATE_ALLOWED)
:SYSTEM.MODE
Cannot seem to find the right get method.
Any ideas?
Thanks,
Kevin
|
|
|
Re: Query_Only Mode [message #484457 is a reply to message #484453] |
Tue, 30 November 2010 12:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
A form is opened in a query mode if a form that calls it specifies so, using the QUERY_ONLY query mode parameter in CALL_FORM or NEW_FORM. So, that would be a "form property", not a block property. Though, as there's no "query mode" property for a form, I wouldn't know how to distinguish whether a form is opened in a query mode or not.
I did some quick Googling, but couldn't find anything "easy". If you wish, check this solution. I didn't read it carefully, but you might.
Why do you need that information, anyway?
|
|
|
Re: Query_Only Mode [message #484460 is a reply to message #484457] |
Tue, 30 November 2010 14:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Kevin58
Messages: 79 Registered: January 2009
|
Member |
|
|
Thanks for the reply Littlefoot!
The reason goes back to my earlier question about enable or disabling fields on a form based on whether or not the report date was filled in.
I call these forms either with no_query_only or query_only depending on that same date field being entered.
I have a jar file that I used to either update or read
several columns from a single data row.
The jar file handles the notepad like object on my form.
However I do not want to invoke those programs unless the user can actually update that record.
Kind of an odd duck so to speak.
So if I can tell how the form was called I could conditionally invoke the java code.
Thanks,
Kevin
|
|
|