no constraints at all

Nulls are allowed, no default values

Tis just a varchar(50)

--- In firebird-support@yahoogroups.com, Alan J Davies <Alan.Davies@...> wrote:
>
> 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
> >
>