| Subject | Unable to insert data into Column |
|---|---|
| Author | call.assist |
| Post date | 2011-12-09T11:46:13Z |
Firebird v2.1.3 classic on Linux
We have a table with a column on it, which when we run a simple sql to insert a new row with data in that column it doesnt populate the column
(simple varchar(50) )
it works for all other columns in the table, and works for updates
if i do a backup/restore to a new database it works again and i can update the column, but as we are a 24/7 company id rather not take the DB down if possible.
Anyone any ideas why this has happened and another suggestion to fix?
Cheers
Andrew
We have a table with a column on it, which when we run a simple sql to insert a new row with data in that column it doesnt populate the column
(simple varchar(50) )
it works for all other columns in the table, and works for updates
if i do a backup/restore to a new database it works again and i can update the column, but as we are a 24/7 company id rather not take the DB down if possible.
Anyone any ideas why this has happened and another suggestion to fix?
Cheers
Andrew