OraFAQ Forum: Forms » Dynamic table in form

Home » Developer & Programmer » Forms » Dynamic table in form (6i)

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

Dynamic table in form [message #536701]

Thu, 22 December 2011 04:34

Tomcrzy
Messages: 101
Registered: December 2011
Location: Chennai,India

Senior Member

Hi,

Can anyone help me to create a table in forms .
i tried to do it with forms_table(--) but i am in confusion.

Report message to a moderator

Re: Dynamic table in form [message #536702 is a reply to message #536701]

Thu, 22 December 2011 04:38

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why would you want to create a table from a form? Generally speaking, this is a wrong approach. In Oracle, create table once (using SQL*Plus or similar client) and use it many times (from a form, for example). People whose background is MS SQL Server, this is strange but hey - that's how Oracle works. You don't need to create/drop tables on-the-fly.

So - why do you need to create a table from a form?

P.S. Is it possible? Certainly it is! Use FORMS_DDL built-in.

Report message to a moderator

Re: Dynamic table in form [message #536703 is a reply to message #536702]

Thu, 22 December 2011 04:43

Tomcrzy
Messages: 101
Registered: December 2011
Location: Chennai,India

Senior Member

In situations like end user does not aware about sql and he is using the form just for creating a table

i will specify what i am actually need

a block for entering table name
and one or two set of blocks for column details

eg:-one for columnname and other two are for datatype and length

user -after entering these details by pressing a button table should created...

please help me to get this

Report message to a moderator

Re: Dynamic table in form [message #536705 is a reply to message #536703]

Thu, 22 December 2011 04:45

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Heh? Why should an end user create tables in the first place?!? What would he do with that table?

Anyway: FORMS_DDL again (just in case you didn't see it previously).

Report message to a moderator

Re: Dynamic table in form [message #536711 is a reply to message #536705]

Thu, 22 December 2011 05:10

Tomcrzy
Messages: 101
Registered: December 2011
Location: Chennai,India

Senior Member

Thanks little foot

i missed to do the quotes

forms_ddl('create table '||:b.tablename||'('||:b.col1||' '||:b.datatype1||'('||:b.length1||'),'||:b.col2||' '||:b.datatype2||'('||:b.length2||'))');

Report message to a moderator

Previous Topic:	It's big problem
Next Topic:	Variable can't hold 4000 characters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 25 21:30:34 CDT 2024