OraFAQ Forum: Forms » default

Home » Developer & Programmer » Forms » default_where

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

default_where [message #146381]

Thu, 10 November 2005 02:07

aarontan78
Messages: 63
Registered: August 2005

Member

Hi,

I have this pre-query which I set the default_where as follows:

DECLARE
BEGAN
go_block('COMU04');
SET_BLOCK_PROPERTY('COMU04', DEFAULT_WHERE, 'COMU = :global.comu
AND EXISTS (SELECT acai FROM ACCI WHERE ACCIS = :global.accis AND gjenis = :COMU04.v_gjenis AND gsek = :COMU04.v_gsek
AND acut IN (''T'',''U'') and acus = ''A'' AND acai = COMU04.acai) AND PAK1.USER1(:global.id1, comucd, :global.nose, kunci) =

''Y''');
END;

I got error: CANNOT READ FORM when I tried to open the form.

Please help!
Thanks.

Regards..

[Updated on: Thu, 10 November 2005 02:10]

Report message to a moderator