GST Billing Software

header image

New Column is Added to an Old Database Table

Erachana Line

76. What happens when a new column is added to an old database table? How to handle controls and grid columns in this case?

When a new column is added to the database table, in the form, it is mandatory to add a new control and also a grid column that are associated with the table and column. The control/grid column can be associated with the column in the same way as new controls are associated with table columns. It is left to the user to either show the control and respective grid column, or hide it, but it is important that some data is saved into the database column through that control. If a new control is not added to associate with the new database column, errors will be thrown.