Can not edit column names

Derby - related issues
Post Reply
Tom
Posts: 2
Joined: Tue Aug 30, 2011 10:43 am

Can not edit column names

Post by Tom » Tue Aug 30, 2011 10:49 am

Hi, I have a problem with editing my column names.
It is not editable. Why is that?

Thanks.
Attachments
dbSchema.png
dbSchema.png (8.41 KiB) Viewed 19343 times

Tom
Posts: 2
Joined: Tue Aug 30, 2011 10:43 am

Re: Can not edit column names

Post by Tom » Tue Aug 30, 2011 2:27 pm

Another error. I created the sudents table with sql statement.

Code: Select all

CREATE TABLE sekit.students
(
id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
name VARCHAR(24) NOT NULL,
address VARCHAR(1024),
CONSTRAINT primary_key PRIMARY KEY (id)
) ;
It works, the problem is that it places default value as autoincrement instead of checking the check box. So if I create a table within dbSchema I cant add auto increment property.To do so I have to add this STRING"AUTOINCREMENT: start 1 increment 1" as default value of the column, but i does not allow me because it expect an INTEGER value.
Attachments
dbSchema2.png
dbSchema2.png (51.69 KiB) Viewed 19340 times

donose.mihai
Posts: 470
Joined: Thu Apr 07, 2011 11:05 am

Re: Can not edit column names

Post by donose.mihai » Wed Aug 31, 2011 6:51 am

Tom wrote:Hi, I have a problem with editing my column names.
It is not editable. Why is that?

Thanks.

Hi Tom,

Dbschema executes an alter table in the background when you change a table name, it look like this statement either was not implemented or it has an error in it, we'll solve it in our next update, thanks for letting us know about it.

donose.mihai
Posts: 470
Joined: Thu Apr 07, 2011 11:05 am

Re: Can not edit column names

Post by donose.mihai » Wed Aug 31, 2011 6:53 am

Tom wrote:Another error. I created the sudents table with sql statement.

Code: Select all

CREATE TABLE sekit.students
(
id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
name VARCHAR(24) NOT NULL,
address VARCHAR(1024),
CONSTRAINT primary_key PRIMARY KEY (id)
) ;
It works, the problem is that it places default value as autoincrement instead of checking the check box. So if I create a table within dbSchema I cant add auto increment property.To do so I have to add this STRING"AUTOINCREMENT: start 1 increment 1" as default value of the column, but i does not allow me because it expect an INTEGER value.
Noted, it will be solved in the next update.

firionicable
Posts: 25
Joined: Wed Mar 14, 2012 8:01 am

Re: Can not edit column names

Post by firionicable » Fri Mar 16, 2012 5:34 am

donose.mihai wrote:

Hi Tom,

Dbschema executes an alter table in the background when you change a table name, it look like this statement either was not implemented or it has an error in it, we'll solve it in our next update, thanks for letting us know about it.
Nice. I can finally use DBschema again once I get the latest version where this problem has been fixed. Thanks.

liana
Posts: 1
Joined: Thu Sep 18, 2014 10:50 am

Re: Can not edit column names

Post by liana » Thu Sep 18, 2014 10:55 am

Foreign-Keys now work as expected - could it have been a backwards-compatibility issue? The project I used is relatively old (possibly from DBSchema 5.x)

serizawa1234
Posts: 2
Joined: Sat Sep 05, 2015 4:33 am

Re: Can not edit column names

Post by serizawa1234 » Tue Sep 08, 2015 8:19 am

but i does not allow me because it expect an INTEGER value.

Post Reply