Posted on 2006-07-20
I have a column(Adj Reason) in Powerbuilder window, which contains a dropdown data window.
Display value is : adj_reason_desc
Data Value is : adj_reason_cd
Dropdown datawindow data source is a procedure. Data window have 3 columns like adj_reason_cd, adj_reason_desc and adj_class.
Procedure is simply getting data from bill_adj table without any input parameters.
In bill_adj table, the data is like
adj_reason_cd adj_class adj_reason_desc last_update_ts last_update_userid
500 M Demand Change 1/1/2006 RS94878
501 S Emergency Svc 3/2/2006 VV88777
(the last one adj_reason_desc is space)
My requirement is when ever user select space value (adj_reason_desc), I mean adj_reason_cd is 999. I need to give access for entering some desc on that column and need to stores to the bill_adj table as
999 M User entered desc 7/20/2006 user userid
How can I insert adj_reason_desc column thru this dropdowndatawindow.
Thanks for your advance help.