Home » Developer & Programmer » Forms » Dynamic Column Creation (Oracle 9i, Developer 6i and Win 2000)
Dynamic Column Creation [message #352022] Sun, 05 October 2008 05:46 Go to next message
mahatab
Messages: 98
Registered: January 2008
Location: Dhaka
Member

Dear All,
I just wanted to know from the experts that is it possible to create any column dynamically in the table from the form when i wanted to insert any data for what no column is present in the table and the data type may be any thing. If it is so,can any one please provide me any help with a sample piece of code. Thanks in advance.

Mahatab, Bangladesh.
Re: Dynamic Column Creation [message #352025 is a reply to message #352022] Sun, 05 October 2008 06:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you need that you have a BIG bug in your application.

Regards
Michel
Re: Dynamic Column Creation [message #352073 is a reply to message #352022] Sun, 05 October 2008 23:57 Go to previous messageGo to next message
mahatab
Messages: 98
Registered: January 2008
Location: Dhaka
Member

Thanks for the reply, but will you please explain it a more, i wanted to know why there will be bug in the application?
Re: Dynamic Column Creation [message #352077 is a reply to message #352073] Mon, 06 October 2008 00:15 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Because it is not the way it should be done.

OK, it is possible to add a column into a table during runtime; obviously, you'll need to use the ALTER TABLE command which is to be run via FORMS_DDL built-in.

But, who will know you have done that? How do you expect other parts of application will know about it? Would you like your reports to reflect this change automatically as well? What about packages? Procedures, functions? How will you display these newly created columns in your forms?
Previous Topic: using POST in trigger
Next Topic: Form at run time
Goto Forum:
  


Current Time: Fri Dec 09 21:08:40 CST 2016

Total time taken to generate the page: 0.09883 seconds