|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Building a Customer information form [message #423528 is a reply to message #423425] |
Fri, 25 September 2009 02:00   |
aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad
|
Member |
 
|
|
Hello All,
I have started the form and got struck in getting the payment details in my child records when i enter the customer name and number and press find button to get the details of payment receipt details....
I have used this code in find push button -----------
Declare
x varchar2(50):=:HOPE_CUSTOMER_FORM_X.customer_number;
y varchar2(200):=:HOPE_CUSTOMER_FORM_X.customer_name;
cursor c1 is select account_number,payment_method,receipt_number,receipt_date,code,amount,status,gl_date,functional_amount
from HOPE_PAYMENT_FORM_X
where HOPE_PAYMENT_FORM_X.account_number=x;
Begin
message(y);
--select customer_number into x from HOPE_CUSTOMER_FORM_X where customer_name=y;
open c1;
loop
--message(x);
fetch c1 into
:HOPE_PAYMENT_FORM_X.account_number,
:HOPE_PAYMENT_FORM_X.payment_method,
:HOPE_PAYMENT_FORM_X.receipt_number,
:HOPE_PAYMENT_FORM_X.receipt_date,
:HOPE_PAYMENT_FORM_X.code,
:HOPE_PAYMENT_FORM_X.amount,
:HOPE_PAYMENT_FORM_X.status,
:HOPE_PAYMENT_FORM_X.gl_date,
:HOPE_PAYMENT_FORM_X.functional_amount;
next_record();
--message(:HOPE_PAYMENT_FORM_X.account_number);
exit when c1%notfound;
end loop;
close c1;
End;
But that does't work..I need to get all the receipts under that customer.But instead i am getting only one record by record. I have used tabular form for the feilds.
Kindly help me ASAP...
Thanks in advance
M.A.Aiyaz
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
