OraFAQ Forum: Forms » frm-40505

Home » Developer & Programmer » Forms » frm-40505

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

frm-40505 [message #488514]

Sat, 08 January 2011 09:10

memua
Messages: 27
Registered: January 2011
Location: riyadh

Junior Member

hello

i have a button to delet a record

WHEN BUTTON PRESSED
WITH IN THIS TRIGGER I PLACED THIS CODE

BEGIN
IF SHOW_ALERT('DELETE') = ALERT_BUTTON1 THEN
DELETE_RECORD;
EXECUTE_QUERY;
END IF;
END;

EVERY TIME I PRESS THE BUTTON I GET THIS FRM-40505 CANNOT EXECUTE QUERY

PLEASE HELP ME

THANKS

Report message to a moderator

Re: frm-40505 [message #488516 is a reply to message #488514]

Sat, 08 January 2011 09:28

memua
Messages: 27
Registered: January 2011
Location: riyadh

Junior Member

please help it wont even let me update how can i solve this problem
for your kind support

Report message to a moderator

Re: frm-40505 [message #488520 is a reply to message #488516]

Sat, 08 January 2011 11:46

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use display error on the help menu to see what the problem is.

Report message to a moderator

Re: frm-40505 [message #488529 is a reply to message #488520]

Sat, 08 January 2011 13:41

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

Senior Member
Account Moderator

I suspect that a button belongs to a non-database block. Perhaps your code misses the "GO_BLOCK" built-in (i.e. first go to a database block, then delete a record and execute query).

Report message to a moderator

Previous Topic:	accentuation
Next Topic:	forms 10g r2 to forms 10g r1 compatibility issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:37:53 CDT 2024