Re: Where clause
Date: Wed, 16 Sep 1998 23:14:15 GMT
Message-ID: <3600398e.7149916_at_news.mad.ibernet.es>
El Tue, 15 Sep 1998 19:19:04 GMT, gayatribalaji_at_my-dejanews.com escribio:
>Hi all,
>
>Forms 4.5,oracle client server7.x
>
>Iam trying to set the query where clause using the
>SET_BLOCK_PROPERTY('BLOCK_NAME',DEFAULT_WHERE,TABLENAME_COLUMN = :block_item);
>Trigger:Prequery block level.
>
The default where clause type is char. Maybe you missed the single
commas ('):
I've tried this two ways and both them work fine:
SET_BLOCK_PROPERTY('BLOCK_NAME',DEFAULT_WHERE,'TABLENAME_COLUMN =
:block.item');
SET_BLOCK_PROPERTY('BLOCK_NAME',DEFAULT_WHERE, 'TABLENAME_COLUMN =
'''|| :block.item||'''');
In order to check which query is actually being executed, you can display this message, after changing the where clause: MESSAGE(GET_BLOCK_PROPERTY('BLOCK_NAME',DEFAULT_WHERE)); Or even this one after the query has been executed: MESSAGE(:SYSTEM.LAST_QUERY);
-- Best Wishes! Lío. (For mail or reply, change nospam by nexo, like this:) jgonzalezsuare_at_nexo.esReceived on Thu Sep 17 1998 - 01:14:15 CEST