edit constraints?

Pokrewne:

Cytat:

edit constraints?

BugTracker - Czw Lip 26, 2007 6:00 am
" />A bug report

Repeatable: yes

Description:
There is no constraints shown in the dialog when i want to edit table schema. Only master key is checked but the other not. In autoincrement listbox there is bizzare [id] togetehr with ASC and DESC, when i choose e.g. ASC then [id] dissapears immediatelly. Hmmm, that whole dialog seems to be buggy?

Googie - Czw Lip 26, 2007 6:22 am
" />Can anybody explain it? Can anybody give some screenshot of what is the problem? What is the operating system?
...because I can't see any problem with that on my pc :/

Wiaz - Czw Lip 26, 2007 7:20 am
" />Kod:CREATE TABLE [el_modul]
(
[id] INTEGER PRIMARY KEY autoincrement not null ,
[desygnator] VARCHAR (100) not null,
[id_modul] INTEGER references modul (id) not null,
[id_element] INTEGER references element (id) not null,
[uwagi] TEXT,
UNIQUE (id_modul, desygnator )
)

look at the combo boxes!

Second example without any constraint!

Kod:CREATE TABLE [dostawca]
(
[id] INTEGER primary key autoincrement not null,
[nazwa] VARCHAR (100) unique not null,
[uwagi] TEXT
)

Googie - Czw Lip 26, 2007 7:27 am
" />Ok, I see. I'll fix it in beta2.

Darmowy hosting zapewnia PRV.PL