OraFAQ Forum: Forms » post-query/diplay item error

Home » Developer & Programmer » Forms » post-query/diplay item error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

post-query/diplay item error [message #82612]

Fri, 13 June 2003 00:33

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

Report message to a moderator

Re: post-query/diplay item error [message #82614 is a reply to message #82612]

Fri, 13 June 2003 00:48

Maaher
Messages: 7065
Registered: December 2001

Senior Member

And if you try the query in SQL*plus using the same client_no it returns a value?

MHE

Report message to a moderator

Re: post-query/diplay item error [message #82615 is a reply to message #82612]

Fri, 13 June 2003 00:49

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;

Report message to a moderator

Previous Topic:	Locking Problem
Next Topic:	Major Difference between Property class and Visual attribute

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 09:40:34 CDT 2024