Home » Developer & Programmer » Forms » tabular via list item
| tabular via list item [message #332336] |
Tue, 08 July 2008 04:13  |
ambet_epi
Messages: 5
Registered: May 2008
|
Junior Member |
|
|
Hello.. 
Can you guys please help me how to display data/data's in tabular form via list item after pressing or generating the button.
Thanks
ambet
|
|
|
|
|
|
| Re: tabular via list item [message #340540 is a reply to message #338741] |
Wed, 13 August 2008 04:25  |
ambet_epi
Messages: 5
Registered: May 2008
|
Junior Member |
|
|
Not yet Sir David. Please help.. How can i display all the records in my tabular/table? When i generate the execute button, the table shows all the records that i have needed but,all of them inserted or displayed in the same line(first line) with the error message FRM-40102 Record must be entered or deleted. This is my codes:
BEGIN
GO_BLOCK('BLOCK3');
OPEN INQUIRY;
create_record;
LOOP
FETCH INQUIRY INTO lastname, firstname, middlename, contract, prod_code_product, description_product, prod_code_plantype, description_plantype, cc_code, planstatus_status, planstatus_description, lastname_sc, firstname_sc, middlename_sc, ph_pymnt_summary;
EXIT WHEN INQUIRY %NOTFOUND;
down;
:block2.txt_planholders_name:= lastname||' '||firstname||' '||middlename;
:block2.txt_contract_no := contract;
:block2.txt_product_type := description_product;
:block2.txt_plan_type := description_plantype;
:block2.txt_cost_center := cc_code;
:block2.txt_sales_counselor:= lastname_sc||' '||firstname_sc||' '||middlename_sc;
:block2.txt_plan_status := planstatus_description;
END LOOP;
CLOSE INQUIRY;
END;
Waiting for your reply Sir David...
Thanks
Ambet
|
|
|
|
| Re: tabular via list item [message #340563 is a reply to message #340540] |
Wed, 13 August 2008 05:15 |
 |
sasipalarivattom
Messages: 121
Registered: June 2007
Location: Cochin ( INDIA )
|
Senior Member |
|
|
Hi Ambet ,
Is it a data block ?
If yes , why don't you use EXECUTE_QUERY ?
If it is only a control block , try this modifies code
BEGIN
GO_BLOCK('BLOCK3');
OPEN INQUIRY;
create_record;
LOOP
FETCH INQUIRY INTO lastname, firstname, middlename, contract,
prod_code_product, description_product, prod_code_plantype,
description_plantype, cc_code, planstatus_status,
planstatus_description, lastname_sc, firstname_sc,
middlename_sc, ph_pymnt_summary;
EXIT WHEN INQUIRY %NOTFOUND;
:block2.txt_planholders_name:= lastname||' '||firstname||' '||middlename;
:block2.txt_contract_no := contract;
:block2.txt_product_type := description_product;
:block2.txt_plan_type := description_plantype;
:block2.txt_cost_center := cc_code;
:block2.txt_sales_counselor:= lastname_sc||' '||firstname_sc||' '||middlename_sc;
:block2.txt_plan_status := planstatus_description;
down;
END LOOP;
CLOSE INQUIRY;
END;
Regards ,
Sasi..
[EDITED by DJM: Made displayed text narrower]
[Updated on: Mon, 18 August 2008 20:29] by Moderator Report message to a moderator |
|
|
|
| Re: tabular via list item [message #340710 is a reply to message #340563] |
Wed, 13 August 2008 21:08 |
ambet_epi
Messages: 5
Registered: May 2008
|
Junior Member |
|
|
Mr. Sasi,
Sir, It didn't work. What am i going to do? Please Help...
I tried to follow your instructions. My data block(table/tabular) item property is already set to YES. But, nothings gonna happen. Still the same error.
Thanks,
Ambet
|
|
|
|
|
|
| Re: tabular via list item [message #340726 is a reply to message #340715] |
Thu, 14 August 2008 00:59 |
ambet_epi
Messages: 5
Registered: May 2008
|
Junior Member |
|
|
Sir this is my complete code:
PROCEDURE PLANHOLDER_INQUIRY_PRODUCT IS
lastname VARCHAR2(80);
firstname VARCHAR2(80);
middlename VARCHAR2(80);
contract VARCHAR2(80);
prod_code_product VARCHAR2(80);
cc_code VARCHAR2(80);
description_product VARCHAR2(80);
description_plantype VARCHAR2(80);
prod_code_plantype VARCHAR2(80);
lastname_sc VARCHAR2(80);
firstname_sc VARCHAR2(80);
middlename_sc VARCHAR2(80);
planstatus_status VARCHAR2(80);
planstatus_description VARCHAR2(80);
ph_pymnt_summary VARCHAR2(80);
CURSOR INQUIRY IS
SELECT a.lastname, a.firstname, a.middlename, b.contract, c.prod_code, c.description,
d.prod_code, d.description, e.code, f.description, f.code, g.lastname,
g.firstname, g.middlename, h.status FROM planholder a, ph_contract b,
product c, plan_type d, cost_center e, plan_status f, sales_associate g,ph_payment_summary h
WHERE b.prod_code = :LIST_PRODUCT_TYPE AND a.ph_no = b.ph_no
AND c.prod_code = d.prod_code AND b.cc_code = e.code AND b.plan_type = d.code
AND b.prod_code = c.prod_code AND b.sc_code = g.sc_code AND f.code = h.status;
BEGIN
GO_BLOCK('BLOCK3');
OPEN INQUIRY;
CREATE_record;
LOOP
FETCH INQUIRY INTO lastname, firstname, middlename, contract, prod_code_product, description_product,
prod_code_plantype, description_plantype, cc_code, planstatus_status,
planstatus_description, lastname_sc, firstname_sc, middlename_sc, ph_pymnt_summary;
EXIT WHEN INQUIRY %NOTFOUND;
:block2.txt_planholders_name := lastname||' '||firstname||' '||middlename;
:block2.txt_contract_no := contract;
:block2.txt_product_type := description_product;
:block2.txt_plan_type := description_plantype;
:block2.txt_cost_center := cc_code;
:block2.txt_sales_counselor := lastname_sc||' '||firstname_sc||' '||middlename_sc;
:block2.txt_plan_status := planstatus_description;
DOWN;
END LOOP;
CLOSE INQUIRY;
END;
Thanks,
Ambet
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Feb 10 00:19:11 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
