OraFAQ Forum: Forms » execute

Home » Developer & Programmer » Forms » execute_query don't work ! (database 10g , forms 6i , XP SP2)

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

execute_query don't work ! [message #321045]

Sun, 18 May 2008 13:52

Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt

Senior Member

I made simple form , in the first I removed DEFAULT&SMARTBAR in Menu Module from Form Module property palette.
than I made the execute_query button and insert it execute_query built-in with when-button-pressed ... but doesn't work .... and give me this error below :-

http://img137.imageshack.us/img137/3158/exenoterrms9.png

where the wrong here ?
despite that the execute_query built-in work correctly with when-new-form-instance trigger !!!!

P.S. : I attached the fmb file to understand better what happened with me.

Attachment: EXE_NOT.fmb
(Size: 48.00KB, Downloaded 1060 times)

Report message to a moderator

Re: execute_query don't work ! [message #321048 is a reply to message #321045]

Sun, 18 May 2008 15:47

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

Senior Member
Account Moderator

There are items whose "Required" property is set to YES, so Form expects these items to be entered before proceeding with a query. Make them non-required and validate their existence in, for example, WHEN-VALIDATE-ITEM or WHEN-VALIDATE-RECORD trigger.

Report message to a moderator

Re: execute_query don't work ! [message #321322 is a reply to message #321045]

Mon, 19 May 2008 21:04

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please just post the code that you have under the button.

David

Report message to a moderator

Re: execute_query don't work ! [message #322630 is a reply to message #321045]

Sun, 25 May 2008 07:01

Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt

Senior Member

the problem has been solved ..... I put ( MOUSE NAVIGATE to NO ) for the "EXECUTE_QUERY" button and the execution worked correctly.

download the attachment to test my last result.

Attachment: EXE_NOT.fmb
(Size: 48.00KB, Downloaded 1063 times)

Report message to a moderator

Re: execute_query don't work ! [message #323592 is a reply to message #321045]

Wed, 28 May 2008 23:35

madhuri_madhav
Messages: 8
Registered: May 2008
Location: Hyderabad

Junior Member

You should put the push button 'execute_query' in another block.
So, create one block through Object Navigator. Drag the push button to a new block. Then execute the form. You will get result 100%.

Report message to a moderator

Previous Topic:	connect two database same tame
Next Topic:	List Item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 12:18:12 CDT 2024