Re: Where clause

From: (wrong string) ío <jgonzalezs_at_nospam.es>
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.es
Received on Thu Sep 17 1998 - 01:14:15 CEST

Original text of this message