@yahoogroups.com
Subject: Re: [firebird-support] Alter column not null with constraint name FB3
On 24-4-2018 20:47, 'livius' liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>
>
> >
> > Hi,
> > I need to add Field not null constraint with my custom name.
> > in previo
On 24-4-2018 20:47, 'livius' liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>
>
> >
> > Hi,
> > I need to add Field not null constraint with my custom name.
> > in previous versions of Firebird we can do:
> > 1. ALTER TABLE XXX ADD FIELDX INTEGER CONSTRAINT NK_XXX__FIELDX NOT NULL;
>
> Hi,
> I need to add Field not null constraint with my custom name.
> in previous versions of Firebird we can do:
> 1. ALTER TABLE XXX ADD FIELDX INTEGER CONSTRAINT NK_XXX__FIELDX NOT NULL;
>>Interestingly, that syntax is not documented in the Firebird 2.5
>>language reference.
it has been
On 24-4-2018 15:40, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 24-4-2018 09:34, liviuslivius liviusliv...@poczta.onet.pl
> [firebird-support] wrote:
>>
>>
>> Hi,
>> I need to add Field not null constraint with my custom name.
>> in previous versions of Firebird we can do:
On 24-4-2018 09:34, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>
>
> Hi,
> I need to add Field not null constraint with my custom name.
> in previous versions of Firebird we can do:
> 1. ALTER TABLE XXX ADD FIELDX INTEGER CONSTRAINT NK_XXX__FIELDX NOT NULL;
Hi,
I need to add Field not null constraint with my custom name.
in previous versions of Firebird we can do:
1. ALTER TABLE XXX ADD FIELDX INTEGER CONSTRAINT NK_XXX__FIELDX NOT NULL;
2. UPDATE TABLE XXX SET FIELDX=some calculations;
Now in Firebird 3 this is prohibited on table with data.