Adding a column (OpenInsight Specific)
At 16 OCT 1998 06:31:06AM Jacob Ignatius wrote:
If I want to add a column to a table that has thousands of records without destroying the data integrity, how do I do it? Can I simply open the table up in Table Builder and add the column? Would this destroy the data integrity? Do I have to create a new table including the new column and transfer the original records into the new table.
At 16 OCT 1998 08:15AM MS wrote:
There is no problem with Adding or Removing Columns on an LH Table. Its as simple as you think.
At 16 OCT 1998 09:05AM Dave Pociu wrote:
Creating a new column in a table only means that you now have a dictionary reference to field x of a record in that table.
Because the data is variable-length, the system could care less if the reference is to field 1 or to field 100. It the record extends that far, then you see the data. If the record ends before that, there is nothing to show.
This is quite unlike a regular relational database, where adding a column means that each record in the table has to be brought up to the new standard length.
So, to answer your question: enjoy adding as many columns as you want through Table Builder, nothing else needs to be done, and more important - nothing will break in your application.