| Dynamic Column Creation [message #352022] |
Sun, 05 October 2008 05:46  |
|
|
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 #352077 is a reply to message #352073] |
Mon, 06 October 2008 00:15  |
 |
Littlefoot
Messages: 21823
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
