OraFAQ Forum: Forms » dynamically get the column names

Home » Developer & Programmer » Forms » dynamically get the column names (oracle 10g forms)

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

dynamically get the column names [message #466708]

Tue, 20 July 2010 12:56

kalpataru
Messages: 72
Registered: January 2010
Location: INDIA

Member

hi gurus,
i have listitem populated with many table names from a schema.
i have grid in oracle forms 10g and i want to fill the grid with at least four/more columns.
i want to fire the list change trigger when each time any one table name is selected.

how can i find the columns names dynamically
for filling the grid..

Report message to a moderator

Re: dynamically get the column names [message #466716 is a reply to message #466708]

Tue, 20 July 2010 14:10

jenasatyabrata82
Messages: 21
Registered: July 2009
Location: INDIA

Junior Member

Trying on your own is the best chance to learn a new thing.
Solving a problem by searching for "concepts",
and then trying to use those concepts,
improves our knowledge,but directly asking the questions ,
and taking answer from someone ,is not a good idea.
Hope you understand it.

And when we try to solve problem,our selves,
we also learn a lot of other things,and
it also increases our confidence level.

[Updated on: Tue, 20 July 2010 23:50]

Report message to a moderator

Re: dynamically get the column names [message #466785 is a reply to message #466716]

Wed, 21 July 2010 02:50

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

Senior Member
Account Moderator

Look at the various database tables/synonyms that are available to you or your user and see which you need to use to get the list of 'tables' (eg, 'user_tables') and which you need to use to get the columns (eg, 'user_tab_columns').

David

Report message to a moderator

Re: dynamically get the column names [message #466917 is a reply to message #466716]

Wed, 21 July 2010 12:15

kalpataru
Messages: 72
Registered: January 2010
Location: INDIA

Member

ok boss..

Report message to a moderator

Re: dynamically get the column names [message #466939 is a reply to message #466917]

Wed, 21 July 2010 13:04

jenasatyabrata82
Messages: 21
Registered: July 2009
Location: INDIA

Junior Member

Like this time you solved your problem by your self,
every time ,you should try like this.

Regards,
Satyabrata

Report message to a moderator

Re: dynamically get the column names [message #467050 is a reply to message #466939]

Thu, 22 July 2010 02:36

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

Senior Member
Account Moderator

You don't have to solve it all by your self, but you really show start to solve it by your self and when you get stuck or have an error we are here to help you.

David

Report message to a moderator

Re: dynamically get the column names [message #467479 is a reply to message #467050]

Sat, 24 July 2010 13:12

kalpataru
Messages: 72
Registered: January 2010
Location: INDIA

Member

hi ,

by getting column names dynamically i am creating a record group
using this below query
SELECT COLUMN_NAME, DATA_TYPE FROM USER_TAB_COLUMNS WHERE TABLE_NAME = <table_name>

but when timestamp datatype is there then it is showing error cannot create group groupname
but the record group is running successful on varchar2,number,date dayatypes

if any alternative is there i mean to say without using record group then tell me or where is the problem

Report message to a moderator

Previous Topic:	Problem At Running Form
Next Topic:	need help with roles/synonyms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 21:45:48 CST 2025