constraints in tabbed view of table

Pokrewne:

Cytat:

Wiaz - Pon Sie 06, 2007 5:43 am
" />in dialog all coinstraints seems to be good, but in tabbesd view of coinstarints (window with datagrid view of constraints)
DDL:
Kod:CREATE TABLE [element]
(

[id] INTEGER PRIMARY KEY autoincrement not null,

[nazwa] VARCHAR
(
100
)
unique not null,

[id_pref_dostawca] INTEGER references dostawca
(
id
),

[id_typ] INTEGER references typ_elementu
(
id
)
not null,

[magazyn] INTEGER default 0,

[magazyn_w_drodze] INTEGER default 0,

[uwagi] TEXT
)

i getKod:typ_elementu (id)
in 'references' column in 4 fields:
id_typ (that is good),
magazyn, magazyn_w_drodze, uwagi (and that is wrong!)

Wiaz - Pon Sie 06, 2007 5:46 am
" />Oh, it is bigger problem than i thought, here is complete mess:

DDL:
Kod:CREATE TABLE [kodcena]
(

[id] INTEGER PRIMARY KEY autoincrement not null,

[id_dostawca] INTEGER references dostawca
(
id
)
not null,

[id_element] INTEGER references element
(
id
)
not null,

[kod] VARCHAR
(
100
),

[cena] decimal
(
10,
2
),

[uwagi] TEXT,

UNIQUE
(
id_dostawca,
id_element
)

)

Googie - Pon Sie 06, 2007 9:52 am
" />One more place with constraints handling messed up. Thanks for the report!

Darmowy hosting zapewnia PRV.PL