OraFAQ Forum: Forms » Default Where Property not working

Home » Developer & Programmer » Forms » Default Where Property not working (Forms 6i)

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

Default Where Property not working [message #469594]

Thu, 05 August 2010 04:42

allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan

Senior Member

i create button and write a trigger on it...
WBP TRIGGER

			 		SET_BLOCK_PROPERTY('EMP_ATTANDANCE', DEFAULT_WHERE, ' ATN_DATE =''''' ||:CONTROL_BLOCK.ATN_DATE || ''''||' AND PERSONAL_INFO_FK IN (SELECT PERSONAL_INFO_PK FROM PERSONAL_INFO WHERE EMP_SAL_FK = '''''||:CONTROL_BLOCK.EMP_TYPE_FK || ''''')');

WHEN I PRESS THE BUTTON THAT CODE NOT WORKING....

MY BLOCK IS DATABASE BLOCK....

PLS HELP ME ...

Report message to a moderator

Re: Default Where Property not working [message #469596 is a reply to message #469594]

Thu, 05 August 2010 04:45

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

Senior Member
Account Moderator

Put that "default where" condition into a variable and either display it in an item or via MESSAGE built-in so that you'd see what you, actually, wrote here. With that many single quotes and concatenation, perhaps you did something wrong (logically). If it still looks OK, take it and write a select in SQL*Plus using that very WHERE clause. Perhaps there are no records that satisfy the condition.

Report message to a moderator

Previous Topic:	plun in not found
Next Topic:	Check Date Correct

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 12:56:02 CDT 2024