Problem with data block "where" clause
From: Dean Peterson <depeters_at_mail.direct.ca>
Date: Mon, 24 May 1999 21:56:52 -0700
Message-ID: <374A2D94.6CB1B825_at_mail.direct.ca>
[Quoted] [Quoted] 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:
Date: Mon, 24 May 1999 21:56:52 -0700
Message-ID: <374A2D94.6CB1B825_at_mail.direct.ca>
[Quoted] [Quoted] 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 Received on Tue May 25 1999 - 06:56:52 CEST