Home » Developer & Programmer » Forms » diplayitem/other column error
diplayitem/other column error [message #82552] Fri, 06 June 2003 22:48 Go to next message
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 Go to previous message
Maaher
Messages: 7064
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
Previous Topic: Backup with form
Next Topic: how to make hierarchical tree
Goto Forum:
  


Current Time: Mon May 16 20:54:52 CDT 2022