Re: Problem with data block "where" clause

Dean Peterson wrote:

> I have a form that has two blocks, a control block and a data block. The
> purpose of the control block is to provide the user with two fields, one
> to enter the name of a column in the data block table, and the other to
> enter a column value so a search on the combination can be performed.
> The where clause in the data block reads as follows:
>
> CTRL_BLOCK.FIELD_NAME like CTRL_BLOCK.FIELD_VALUE
>
> when I try to execute the query on the data block, I receive the
> following error:
> FRM-40505: Processing error encountered. The table associated with the
> current block of the form might not exist, or your username might not
> have the authority to perform the specified action on the table.
>
> Neither of these errors are helpful as the table specified certainly
> does exist, and the username has all priviledges for the system.
>
> Can anyone help!?!
>
> Rosemary Balden

Use something like the following:

set_block_property('DATA_BLOCK', DEFAULT_WHERE, :CTRL_BLOCK.FIELD_NAME || ' like ''' || :CTRL_BLOCK.FIELD_VALUE || ''' '; Received on Fri May 28 1999 - 22:12:18 CEST