Message-Id: <10596.115073@fatcity.com> From: sergio Date: Mon, 21 Aug 2000 10:40:09 +0200 Subject: Re: set_block_propery --------------60A0D3B0D928241EDA9C4D78 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Slavica Sadzakovic wrote: > Can somebody give me example for set_block_property procedure for > where clause. Hi, The way to do it is: SET_BLOCK_PROPERTY('BLOCK_NAME', DEFAULT_WHERE, CLAUSE) Where clause is a string, or string variable like ' ID_EMP=500'. Note that the where clause always have to begin with a space. If you have a composed clause like: ' ID_EMP='||PARAMETER.ID_EMP you must use a string variable --------------60A0D3B0D928241EDA9C4D78 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

Slavica Sadzakovic wrote:

Can somebody give me example for set_block_property procedure for where clause.

Hi,
The way to do it is:

SET_BLOCK_PROPERTY('BLOCK_NAME', DEFAULT_WHERE, CLAUSE)

    Where clause is a string, or string variable like ' ID_EMP=500'.
    Note that the where clause always have to begin with a space. If you have a composed clause like:
       ' ID_EMP='||PARAMETER.ID_EMP
you must use a string variable