OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » Syntax (oracle8i and form6i)

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

Syntax [message #501976]

Fri, 01 April 2011 21:00

mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan

Senior Member

Is the syntax of below assignment statement correct in pre-query trigger? please guide me.

:dshift_dtl.servid := 'select servid from service where servcat = "CR" ';

Report message to a moderator

Re: Syntax [message #501987 is a reply to message #501976]

Sat, 02 April 2011 01:35

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Please try this.

Declare
Svid Number;
Begin
Select  Servid Into  Svid From Service where servcat = "CR";
:dshift_dtl.servid := Svid;
End;

Regards,
Irfan

Report message to a moderator

Re: Syntax [message #501996 is a reply to message #501987]

Sat, 02 April 2011 09:22

mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan

Senior Member

Thanks Irfan i have tried above but not succeeded and found an error FRM-40735:PRE-QUERY trigger raised unhandled exception ORA-01422 . Actually dshift_dtl is a tabular block and its master block is a form block. I wish that when execute_query executed the tabular block should display all child record of the master but its servid should match with another table from where only servcat = 'CR'. Have you any solution.

Report message to a moderator

Re: Syntax [message #502004 is a reply to message #501996]

Sat, 02 April 2011 14:18

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

Senior Member

Set the blocks where clause in the property pallete.

Report message to a moderator

Re: Syntax [message #502007 is a reply to message #502004]

Sat, 02 April 2011 20:07

mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan

Senior Member

I have set the block where clause in the property pallete as

:dshift_dtl.servid := 'select servid from service where servcat = "CR" ';

but it gives error FRM-40735:PRE-QUERY trigger raised unhandled exception ORA-01422.

Report message to a moderator

Re: Syntax [message #502044 is a reply to message #502007]

Sun, 03 April 2011 13:46

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

Senior Member
Account Moderator

It appears that you are guessing the solution (and I'm afraid you won't succeed). Please, open Forms Help and search for SET_BLOCK_PROPERTY. In there, you'll find syntax as well as examples of how to set certain properties.

Report message to a moderator

Previous Topic:	creating menu in 10g
Next Topic:	list of value , entering data in list of value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 04:59:38 CDT 2024