OraFAQ Forum: Forms » how to display two or more columns in a tlist ?help?

Home » Developer & Programmer » Forms » how to display two or more columns in a tlist ?help?

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

how to display two or more columns in a tlist ?help? [message #113457]

Sun, 03 April 2005 16:50

ramisy2k
Messages: 150
Registered: April 2005

Senior Member

Hi

I am facing a huge problem or making a tlist in my devloper 6i..i want the

tlist consisting of 5 columns of my database table...i require the tlist for

my project....

the sample DDL data of the table is given below....

create table t2
(ID NUMBER(2),
team1 varchar2(20),
team2 varchar2(30),
VENUE VARCHAR2(20),
year date)
/

insert into t2 (ID, team1, team2, VENUE, year) values (1,'Australia',

'America','Melbourne','15-03-1860');
insert into t2 (ID, team1, team2, VENUE,year) values

(2,'India','Brazil','London','11-12-1970');
insert into t2 (ID, team1, team2, VENUE, year) values (3,'Pakistan','Sri

Lanka','Colombo','10-01-2005');
insert into t2 (ID, team1, team2, VENUE, year) values

(4,'United-Arab-Emirates','Hong Kong','Sharjah','23-07-2003');
insert into t2 (ID, team1, team2, VENUE, year) values (5,'Bangladesh','New

Zealand','Dacca','25-09-2001');

this is a link of a sample tlist...

http://img175.exs.cx/img175/8840/clip26mg.jpg

i want my tlist in exactly the same format...as shown below the desired

output of columns in the tlist....
http://img17.exs.cx/img17/7182/clip37xr.jpg

1  Australia v America                Melbourne   15-03-1860
2  India v Brazil                     London      11-12-1970
3  Pakistan v Sri Lanka               Colombo     10-01-2005
4  United-Arab-Emirates v Hong Kong   Sharjah     23-07-2003
5  Bangladesh v New Zealand           Dacca       25-09-2001

i would be extremely grateful if someone could do it for me...and make the

respective Procedures and Record Groups through which my desired tlist of 5

columns would be possible...I would alos appreciate if some one send me any

sample tlist form with 2 or more coulmns shown in the tlist...

thnaks in advance,
regards,
Sonali.

Report message to a moderator

Re: how to display two or more columns in a tlist ?help? [message #113475 is a reply to message #113457]

Mon, 04 April 2005 01:35

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

Senior Member
Account Moderator

Think SIX columns not five. Do your formatting in this new column. This column may be actual or virtual. That is, use a function (with pragmas), or a view, or another column in your real table. Then populate the base columns in the tlist with a width of zero so that they can be assigned to return values but will not appear in your display. Good luck.

ps. The sixth column will have a width, will appear in your tlist, but will NOT be assigned to a return column.

Report message to a moderator

Re: how to display two or more columns in a tlist ?help? [message #114674 is a reply to message #113475]

Mon, 04 April 2005 17:12

ramisy2k
Messages: 150
Registered: April 2005

Senior Member

hi djmartin

i have tired but i am unable to do so...would you pls help me....
do u have any smaple form where tlist has two or more columns...
i would appreciate if you could do it for me...

regards,
sonali.

Report message to a moderator

Re: how to display two or more columns in a tlist ?help? [message #114679 is a reply to message #114674]

Mon, 04 April 2005 23:36

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

Senior Member
Account Moderator

Try this ... create a record group LIST_RG.

Make its 'select' statement 'select rownum, team1, team2, team1 || '.v.' ||team2 team1vteam2, venue, year
from t2'. You will have to add the where and order clauses.

In the 'Column Specifications' make:
rownum character 5
team1 character 0
team2 character 0
team1vteam2 character 50
venue character 20
year date (or do a to_char and use a character field)

In your LOV, define the 'record group' as LIST_RG, and in the Column Mapping Properties assign a field to 'return item' for team1, team2, etc but NOT to rownum or team1vteam2.

Report message to a moderator

Re: how to display two or more columns in a tlist ?help? [message #114743 is a reply to message #114679]

Tue, 05 April 2005 07:57

ramisy2k
Messages: 150
Registered: April 2005

Senior Member

hello,
many thanks for ur help and suggestion...actually my requiremnt is to emply tlist only and not LOV...
this tlist will show the list of all matches and when the user will click the repective match it will take him to that respective match's detail form...

i would appreciate if some has any clue of how to use the multi colmn tlist in forms 6i..
regards,
Sonali.

Report message to a moderator

Previous Topic:	Save/Update Multiple Values from Form to Separate Table.
Next Topic:	execute an external .sql file from a Oracle stored procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:35:23 CDT 2024