OraFAQ Forum: Forms » how to create list

Home » Developer & Programmer » Forms » how to create list

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

how to create list [message #117817]

Fri, 29 April 2005 14:26

jhon_doe
Messages: 9
Registered: April 2005

Junior Member

plese help me to create list like flexgrid in vb.
i want to list all from my table to label,but i dont know how

Report message to a moderator

Re: how to create list [message #118061 is a reply to message #117817]

Mon, 02 May 2005 20:26

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Do a search in the Forms reference manual for 'record_group' and 'create_group'. The first is for creating a 'tree', the second is for building a group that can be used in an LOV.

David

Report message to a moderator

Re: how to create list [message #118104 is a reply to message #117817]

Tue, 03 May 2005 01:42

jhon_doe
Messages: 9
Registered: April 2005

Junior Member

i have write this code
PROCEDURE tmpDat IS
BEGIN
declare
cursor tmpCol is select nama from keluarga order by nama asc;
begin
last_record;
for rec in tmpCol loop
create_record;
:bl2.alamat := rec.nama;
end loop;
end;
END;

but i have message "data must be inserted or deleted first".
i want multi record, but how?

Report message to a moderator

Re: how to create list [message #118107 is a reply to message #117817]

Tue, 03 May 2005 02:32

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Is there any rason why you can't base your Block on the table 'keluarga'?

David

Report message to a moderator

Re: how to create list [message #118748 is a reply to message #118104]

Sat, 07 May 2005 15:13

jhon_doe
Messages: 9
Registered: April 2005

Junior Member

i just want to list all my data on table.if i use that procedure,
just last data showed,but not all.
if i have 10 data in table,error message 10 times showed.
maybe i don't know how to set block property.
please!!!

Report message to a moderator

Re: how to create list [message #118800 is a reply to message #117817]

Sun, 08 May 2005 20:25

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Quote:

i just want to list all my data on table.if i use that procedure, just last data showed,but not all. if i have 10 data in table,error message 10 times showed. maybe i don't know how to set block property. please!!!

Okay, lets get our terminology synchronised. A table contains data and lives in a database. There are no tables in an Oracle Form. There are records in blocks, and canvases in windows. Do you want to put data into a table in the database, or do you want to display records from a block on a canvas (in a window)?

In Forms you don't have to 'set' records.

Let's start again. Just use the supplied defaults and the Forms wizards to help you create everything.

Create a new form. Create a new block based on 'keluarga'. Accept all fields for display. Do a CTRL-SHFT-K then CTRL-T to generate your Form.

Run it. Does it work? Do you still get the 'insert / delete' error message?

Where do you want to go from here? / What do you want the form to do now?

David

Report message to a moderator

Re: how to create list [message #119041 is a reply to message #118104]

Tue, 10 May 2005 06:51

subba lakshmi
Messages: 36
Registered: March 2005

Member

i have write this code
PROCEDURE tmpDat IS
BEGIN
declare
cursor tmpCol is select nama from keluarga order by nama asc;
begin
--last_record;

go_block('child block name');
first_record;

for rec in tmpCol loop
create_record;
:bl2.alamat := rec.nama;
end loop;
end;
--END;

check out this

from
subba lakshmi

Report message to a moderator

Re: how to create list [message #119108 is a reply to message #117817]

Tue, 10 May 2005 11:06

lomhanz
Messages: 18
Registered: May 2005
Location: Cebu, Philippines

Junior Member

i think david's solution is the best. table base block is one of the strength of forms, why re-invent the wheel? use the suggested way on how to do it.

lomhanz

Report message to a moderator

Re: how to create list [message #119167 is a reply to message #117817]

Tue, 10 May 2005 20:45

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You sound as though you may have a master-detail form requirement.

Create the master block, create the child block and then build be relationship between them. It DOES work and simple IS best.

David

Report message to a moderator

Re: how to create list [message #119848 is a reply to message #119167]

Mon, 16 May 2005 06:36

jhon_doe
Messages: 9
Registered: April 2005

Junior Member

that's work.
thanks for that all.

Report message to a moderator

Previous Topic:	Help me!
Next Topic:	Joining Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:55:36 CDT 2024