Home » Developer & Programmer » Forms » post-query/diplay item error
post-query/diplay item error [message #82612] Fri, 13 June 2003 00:33 Go to next message
jels
Messages: 29
Registered: April 2003
Junior Member
hi i wrote the query in psot-query trigger
select name into :Sales_order.client_name from client_master where client_master.no=
:sales_order.client_no

but the diplsy item is not showing any values the values r there what may be the error
i tired shift + f1 but its showing any error
pls hlp
jels
Re: post-query/diplay item error [message #82614 is a reply to message #82612] Fri, 13 June 2003 00:48 Go to previous messageGo to next message
Maaher
Messages: 7064
Registered: December 2001
Senior Member
And if you try the query in SQL*plus using the same client_no it returns a value?

MHE
Re: post-query/diplay item error [message #82615 is a reply to message #82612] Fri, 13 June 2003 00:49 Go to previous message
shailender
Messages: 2
Registered: March 2002
Junior Member
Can you verify first if,

1) The post query trigger is firing ? You can put some message in Post Query trigger to verify this.

Also, check to see what is the value assigned to the
block item :sales_order.client_no.

Message ('Start Post Query, Sales Order = ' ||
:sales_order.client_no); pause;
Previous Topic: Locking Problem
Next Topic: Major Difference between Property class and Visual attribute
Goto Forum:
  


Current Time: Mon May 16 20:13:38 CDT 2022