Is there a constraint? e.g. not null, must begin with 'A', cannot be a
duplicate.. etc.

Alan J Davies
Aldis

On 09/12/2011 11:46, call.assist wrote:
> 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
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 2012.0.1873 / Virus Database: 2102/4668 - Release Date: 12/08/11
>