OraFAQ Forum: Forms » set block property

Home » Developer & Programmer » Forms » set block property

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

set block property [message #644766]

Tue, 17 November 2015 01:18

rashid786
Messages: 2
Registered: April 2015
Location: asia

Junior Member

hi experts

i am trying

SET_BLOCK_PROPERTY ('emp', DEFAULT_WHERE, 'job = :control.tjob' and 'DEPTNO = ' ||:control.tdep);

please hoe i solve problem . . .

Thanks
Rashid

Report message to a moderator

Re: set block property [message #644767 is a reply to message #644766]

Tue, 17 November 2015 01:26

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

Senior Member
Account Moderator

WHERE clause should be a valid string; yours is not. Try with

set_block_property('emp', default_where, 'job = ' || :control.tjob ||' and deptno = ' || :control.tdep);

or even

set_block_property('emp', default_where, 'job = :control.tjob and deptno = :control.tdep');

Report message to a moderator

Re: set block property [message #644769 is a reply to message #644767]

Tue, 17 November 2015 01:40

rashid786
Messages: 2
Registered: April 2015
Location: asia

Junior Member

its working ...

Thanks a lot... cheer you.

Report message to a moderator

Previous Topic:	How to create Oracle tree menu and calling form from tree menu ??
Next Topic:	Using BLOBS in Forms 6I

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 14 05:27:12 CST 2025