OraFAQ Forum: Forms » Running In Query Mode

Home » Developer & Programmer » Forms » Running In Query Mode

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

Running In Query Mode [message #186078]

Sat, 05 August 2006 10:11

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

Report message to a moderator

Re: Running In Query Mode [message #186116 is a reply to message #186078]

Sun, 06 August 2006 03:06

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"

Report message to a moderator

Re: Running In Query Mode [message #186117 is a reply to message #186116]

Sun, 06 August 2006 03:13

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;

Report message to a moderator

Re: Running In Query Mode [message #186118 is a reply to message #186078]

Sun, 06 August 2006 03:32

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

Report message to a moderator

Re: Running In Query Mode [message #186121 is a reply to message #186118]

Sun, 06 August 2006 03:53

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

Report message to a moderator

Re: Running In Query Mode [message #186238 is a reply to message #186121]

Mon, 07 August 2006 02:46

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

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

Report message to a moderator

Re: Running In Query Mode [message #186430 is a reply to message #186270]

Mon, 07 August 2006 23:44

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

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

Report message to a moderator

Re: Running In Query Mode [message #186700 is a reply to message #186687]

Wed, 09 August 2006 02:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Running In Query Mode [message #317606 is a reply to message #186700]

Fri, 02 May 2008 03:04

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

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

Report message to a moderator

Re: Running In Query Mode [message #318153 is a reply to message #317606]

Mon, 05 May 2008 23:02

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Running In Query Mode [message #379790 is a reply to message #318153]

Wed, 07 January 2009 23:59

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

Report message to a moderator

Re: Running In Query Mode [message #380028 is a reply to message #379790]

Thu, 08 January 2009 21:05

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 02:39:06 CST 2025