Home » Developer & Programmer » Forms » Running In Query Mode
Running In Query Mode [message #186078] Sat, 05 August 2006 10:11 Go to next message
mathew
Messages: 5
Registered: August 2006
Junior Member
Dear Friend

I got this message FRM-40208 form running in query only cannot change database fields.
this happened only when I run the program through the application menu program
But when I run the program alone it is not give this message and it is inserting
Without any problem.

Please help


Re: Running In Query Mode [message #186116 is a reply to message #186078] Sun, 06 August 2006 03:06 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

check that in the "WHEN NEW FORM INSTANCE" Trigger in the form level doesnot contain "enter query"

if so then remove it or replace it by "execute query"
Re: Running In Query Mode [message #186117 is a reply to message #186116] Sun, 06 August 2006 03:13 Go to previous messageGo to next message
mathew
Messages: 5
Registered: August 2006
Junior Member
Thanks for the reply. But in "When-New-Form-Instance", I am not using 'Enter-Query'

Declare
Begin
NEW_FORM('abc',NO_QUERY_ONLY);
End;
Re: Running In Query Mode [message #186118 is a reply to message #186078] Sun, 06 August 2006 03:32 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

why are you using this

do you call another form "abc" from the current form in the "when new form trigger"??

attach the form and send it if you can

Re: Running In Query Mode [message #186121 is a reply to message #186118] Sun, 06 August 2006 03:53 Go to previous messageGo to next message
mathew
Messages: 5
Registered: August 2006
Junior Member
Dear sir,
Thank you very much. I tried two ways

1) One calling the particular form from another form
2) Secondly did the same directly

Still I was getting the same error. I am not using 'WHEN-NEW-FORM-INSTANCE' in the second case.

Once again thank you very much for your help.
Regards
Re: Running In Query Mode [message #186238 is a reply to message #186121] Mon, 07 August 2006 02:46 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please post the code that you have in your menu item.

What is the first form that has the menu from which you are calling the form with the problem?

Have you read the manual concerning call_form, open_form, and new_form?

David

Upd: Change 'coming' to 'calling'.

[Updated on: Mon, 05 May 2008 23:04]

Report message to a moderator

Re: Running In Query Mode [message #186270 is a reply to message #186238] Mon, 07 August 2006 04:20 Go to previous messageGo to next message
mathew
Messages: 5
Registered: August 2006
Junior Member
Dear sir,

Forget about calling the 'said form' from another form. Even if when I am trying to insert a value on the click of a button which is placed on this form, I am getting this error.

This is a happening after connection this form to the application that we are using. If I open this form, compile and run it and when I try to insert the value, its getting inserted without any error.

Once again thank you very much for your help.

Regards
Re: Running In Query Mode [message #186430 is a reply to message #186270] Mon, 07 August 2006 23:44 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You have neither answered my questions nor advanced your position in solving this error.
Quote:
What is the first form that has the menu from which you are calling the form with the problem?

Answer me that and I will tell you why it is not working!!

David

Upd: Change 'coming' to 'calling'.

[Updated on: Mon, 05 May 2008 23:04]

Report message to a moderator

Re: Running In Query Mode [message #186687 is a reply to message #186430] Wed, 09 August 2006 01:51 Go to previous messageGo to next message
mathew
Messages: 5
Registered: August 2006
Junior Member
Sir,
In the first form, the trigger that I am using is 'WHEN-NEW-FORM-INSTANCE'.

Declare
Begin
NEW_FORM('ABC',NO_QUERY_ONLY);
End;

After complying and running with the above code, the things are working fine. But after connection to our application, its showing the error.

Once again thank you very much

Regards
Re: Running In Query Mode [message #186700 is a reply to message #186687] Wed, 09 August 2006 02:34 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Interesting, I really thought you were doing a Call_Form from a form that was running in query only mode because of the following:
CALL_FORM restrictions

Form Builder ignores the query_mode parameter when the calling form is running in QUERY_ONLY mode. Form Builder runs any form that is called from a QUERY_ONLY form as a QUERY_ONLY form, even if the CALL_FORM syntax specifies that the called form is to run in NO_QUERY_ONLY (normal) mode.

Check that your calling form is NOT in query only mode and verify that you really ARE doing a New_Form and not a Call_Form.

David
Re: Running In Query Mode [message #317606 is a reply to message #186700] Fri, 02 May 2008 03:04 Go to previous messageGo to next message
psjetha
Messages: 1
Registered: May 2008
Location: Bangalore
Junior Member
djmartin wrote on Wed, 09 August 2006 02:34
Interesting, I really thought you were doing a Call_Form from a form that was running in query only mode because of the following:
CALL_FORM restrictions
Form Builder ignores the query_mode parameter when the calling form is running in QUERY_ONLY mode. Form Builder runs any form that is called from a QUERY_ONLY form as a QUERY_ONLY form, even if the CALL_FORM syntax specifies that the called form is to run in NO_QUERY_ONLY (normal) mode.

Check that your calling form is NOT in query only mode and verify that you really ARE doing a New_Form and not a Call_Form.

David


Hi David,

I have some problem on same topic.
I a,m also using the call_form with query_only parameter it is giving me the same message when i try to insert or update the record.
"Form running in query-only mode. Cannot change database fields. "

but i don't want to this message. i want to replace it with my own business massege.
like:
"It is protected field "
how can i do this thing.

is it possible suggest me.

Thanks
psjetha
Re: Running In Query Mode [message #318153 is a reply to message #317606] Mon, 05 May 2008 23:02 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at the online help and search this forum for 'error_code'. There are examples on how to trap the 'error' and issue your own message.

David
icon7.gif  Running In Query Mode [message #379790 is a reply to message #318153] Wed, 07 January 2009 23:59 Go to previous messageGo to next message
mackey155
Messages: 5
Registered: January 2009
Junior Member
Hi i wanted to know if theres anyway you can get a form that is called from another form which is query_only, to be no_query_only... its just that the form (query_only) calls another form which has to fill some fields the moment is called and it wont do it since it is in query_only mode ... so what could i do?.
Thx
Re: Running In Query Mode [message #380028 is a reply to message #379790] Thu, 08 January 2009 21:05 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Don't have the first form in 'query_only' mode but simply have all the blocks or items defined with 'update' and 'insert' turned off.

David
Previous Topic: Thai not support
Next Topic: Need Java bean Help in Oracle6i forms
Goto Forum:
  


Current Time: Wed Dec 07 18:53:48 CST 2016

Total time taken to generate the page: 0.06785 seconds