Cannot set DB comuln properties when adding a column

Classic Servoy
1

Hi, trying to add a new column to an existing table, I can change the name, type, lenght, but I cannot change “Allow null” and “Primary key” values. The “Allow Null” automatically flagged as 1 and primary key as 0…

Anyone else experiencing this?

Paul

Using 2.0 RC9

2

You can not change the allow null value (yet) and the primary key is already set by default to columnameid by servoy. I can imagine you can’t change that unless you use an external tool.

3

I don’t believe this to be true.

When I create a completely new table, I can set the “Primary key” and “Allow Null” value for each colomn I add.

I think in the past I was also able to do this for new columns in existing tables… But now I cannot…

I do know that Servoy does not allow you to alter existing columns (very good reasons, that is…)

Paul

4

Sorry Paul, you are right. I read too fast and thought you were editing the table…

5

NP. but is is just me, or do you also have the same behavior?

6

I just tested this. No issue at all. Not with the pk and not with setting the allow null values… (firebird)

7

That is very odd… I’m using firebird as well…

Copied and renamed the Empty.gdb and renamed it and ran into this issue. Then tested it on “old” databases and found the same problem…

Servoy people, any idea?

8

this is the same as [u]here[/u]

9

tnx Jan, sorry I didn’t see that myself. It’s very clear now

Paul