OraFAQ Forum: Forms » Default_where property in data block

Home » Developer & Programmer » Forms » Default_where property in data block

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

Default_where property in data block [message #79563]

Fri, 21 June 2002 22:15

mani
Messages: 105
Registered: September 1999

Senior Member

hai ....
i need to set default_where property either at run time or design time....
inside that where clause i have stings....i mean i have to use single quotes(')......

i have tried setting .....but i could not execute query........can anyone pls send me exactly how to use where claus at desin time......note that in that where clause am using values inside text items......

Thanks in advance...
Mani

Report message to a moderator

Re: Default_where property in data block [message #79566 is a reply to message #79563]

Fri, 21 June 2002 23:43

Remash
Messages: 52
Registered: November 2000

Member

Hi

Here is an example

SET_BLOCK_PROPERTY('EMP',DEFAULT_WHERE,'JOB = '||''''||:TITLE||'''');

Four single quotes will be replaced with one single quote.

Report message to a moderator

Re: Default_where property in data block..still not clear.... [message #79569 is a reply to message #79563]

Sat, 22 June 2002 01:23

mani
Messages: 105
Registered: September 1999

Senior Member

why this text(&#124) is used in default where clause....and where exactly i have to use this text....

if that is for appending i have used ||..but its not working.....please help me....

Report message to a moderator

Re: Default_where property in data block [message #79653 is a reply to message #79563]

Mon, 01 July 2002 02:53

NV
Messages: 6
Registered: June 2002

Junior Member

hai..

The syntax is as follows:

SET_BLOCK_PROPERTY('DATA BLOCK NAME',DEFAULT_WHERE,'CONDITION');

FOR EXAMPLE:

SET_BLOCK_PRPOERTY('EMP',DEFAULT_WHERE,'EMPNO=:EMP.EMPNO');

Hope this will work out..

If u still have any prob, do mail to me..

Bye

Report message to a moderator

Re: Default_where property in data block..still not clear.... [message #81336 is a reply to message #79569]

Wed, 05 February 2003 08:14

Silvana
Messages: 1
Registered: February 2003

Junior Member

set_block_property('ta_activo', DEFAULT_WHERE,
'cod_empresa_padre= '||:global.cod_empresa||
' AND cod_activo_padre= '||
'(select cod_activo_padre from ta_activo
where cod_activo = '||nvl(:ta_activo.cod_activo_padre,0) ||
' and cod_empresa = '||:global.cod_empresa ||
' and nivel= ' ||nvl(:ta_activo.nivel_padre,0)||')'||
' and nivel_padre= '||nvl(:ta_activo.nivel_padre-1,0) );

Report message to a moderator

Previous Topic:	D2K connectivity problem with oracle 8i
Next Topic:	Screen Dump

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:24:44 CDT 2024