diplayitem/other column error [message #82552] |
Fri, 06 June 2003 22:48 |
jels
Messages: 29 Registered: April 2003
|
Junior Member |
|
|
hi How to include one column of other column to display item in one datablock.When i wrote this query in post-query in block level
the query is
select name into :sales_order_blk.client_name from client_master where
client_master.client_no = :sales_order_blk.cleint_no;
when i am trying to press the first button that contains
execute_query it showing error invalid colum.How to solve this error (how to select one column from other table to diplay item)
pls hlp jels
|
|
|
Re: diplayitem/other column error [message #82563 is a reply to message #82552] |
Tue, 10 June 2003 00:22 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
Most probably, the property 'Database column' of the destination item is set to 'Yes'. Set it to 'No'. If you encounter this error, pressing SHIFT+F1 shows the statement Forms is trying to execute. This can give you a good indication of what is going wrong.
MHE
|
|
|