Hi!

I want to remove NOT NULL flag from a field - from SQL.
But this is not working:

alter table t redefine f null;

The setting was this:

alter table t redefine f not null;

Thanks for your help:
  dd

Don't have 3.x manuals handy but in 4.x I think the keyword is nullable so
try with that.

Raul


"durumdara" <durumdara@gmail.com> wrote in message
news:5871827D-324D-40CE-BB6B-11A93E4DF06E@news.elevatesoft.com...
> Hi!
>
> I want to remove NOT NULL flag from a field - from SQL.
> But this is not working:
>
> alter table t redefine f null;
>
> The setting was this:
>
> alter table t redefine f not null;
>
> Thanks for your help:
>   dd
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 4783 (20100118) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4783 (20100118) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

<< I want to remove NOT NULL flag from a field - from SQL. >>

You can't do so with DBISAM 3.30.  You can do so with DBISAM 4.x, however,
using the NULLABLE keyword.

You'll have to use the code-based TDBISAMTable.RestructureTable method to do
so.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:1F014450-C786-41BB-8D2D-6B0059508071@news.elevatesoft.com...
>
> << I want to remove NOT NULL flag from a field - from SQL. >>
>
> You can't do so with DBISAM 3.30.  You can do so with DBISAM 4.x, however,
> using the NULLABLE keyword.
>
> You'll have to use the code-based TDBISAMTable.RestructureTable method to
> do so.
>

or rename, add the field correctly, transfer the data, delete the old field.
I know, I know, but it works.

Robert

Robert,

<< or rename, add the field correctly, transfer the data, delete the old
field. I know, I know, but it works. >>

Yes, that will also work.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:


<< I want to remove NOT NULL flag from a field - from SQL. >>
You'll have to use the code-based TDBISAMTable.RestructureTable method to do
so.

Can you show me a very-very little example?
I can reset this field (named "A") property ("NULLABLE") on table "T".

Thanks for it:
  dd

Required property determines if field value has to exists  - meaning can it
be null or not.

This was never done IDE, lacks any checking of T or A and assumes defaults
in RestructureTable but could roughly  be something like this :

....
T.RestructureFieldDefs.Update;
T.RestructureFieldDefs[T.RestructureFieldDefs.IndexOf('A')].Required :=
false;
T.RestructureTable;
....

Raul

> Can you show me a very-very little example?
> I can reset this field (named "A") property ("NULLABLE") on table "T".
>
> Thanks for it:
>   dd



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4790 (20100120) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com