SqlDbx Forum

vgroch

Member

Edit table data

Im trying to use function "EDIT TABLE DATA" but it gives me error code...

"Unable to Edit Table data. No unique constraints (PRIMARY KEY, UNIQUE, IDENTITY) found"

When i run Table Properties  there is defined Constraint

Name: PK_TC1
Type:  PRIMARY KEY
Clustered: CLUSTERED
Unique: UNIQUE

Do you know where is problem?

thanks

im using SYBASE ASE 15.0.2 and connection is defined with Sybase DSEdit Utility/15.0

p.s. program is great, there is lot of usefull features and running withou problem (connection, select, update,..)

sqldbxhelp

Administrator

Re: Edit table data

Strange. Can you post create statement for this table.

vgroch

Member

Re: Edit table data

Here it is

CREATE TABLE D3000S.USER_TC1
    (
    SPID T_CISLOPOLOZKY(10,0) NOT NULL,
    NO_POLOZKY T_CISLOPOLOZKY(10,0) NOT NULL,
    PRODUKT T_CISLOARTIKLU NULL,
    VARIANTA T_VARIANTAPRODUKTU(6,0) NULL,
    TYP_POLOZKY T_STATUS(1,0) NULL,
    NO_VYKRESU T_CISLOVYKRESU NULL,
    NO_ARTIKLU T_CISLOARTIKLU NULL,
    NO_SKLADU T_KODSKLADU NULL,
    POCET_CISTY T_MNOZSTVI(14,5) NULL,
    POCET_SPOTREBNI T_MNOZSTVI(14,5) NULL,
    NO_PARTNERA T_CISLOPARTNERA(8,0) NULL,
    NO_PRIJEMCE T_CISLOPARTNERA(8,0) NULL,
    NO_REFERENTA T_CISLOPARTNERA(8,0) NULL,
    PRIBAL_DILEC T_STATUS(1,0) NULL,
    POPIS VARCHAR(255) NULL,
    ROZMER_X T_ROZMER(14,2) NULL,
    ROZMER_Y T_ROZMER(14,2) NULL,
    ROZMER_Z T_ROZMER(14,2) NULL,
    DELKA T_ROZMER(14,2) NULL,
    SIRKA T_ROZMER(14,2) NULL,
    VYSKA T_ROZMER(14,2) NULL,
    CENA1 T_OBNOS(14,2) NULL,
    CENA2 T_OBNOS(14,2) NULL,
    CENA3 T_OBNOS(14,2) NULL,
    POZNAMKOVY_BLOK T_POZNAMKOVYBLOK NULL,
    DXF_1 T_POZNAMKOVYBLOK NULL,
    DXF_2 T_POZNAMKOVYBLOK NULL,
    DXF_3 T_POZNAMKOVYBLOK NULL,
    NAZOV VARCHAR(255) NULL,
    TYP_PRODUKTU T_CISLOARTIKLU NULL,
    CONSTRAINT PK_TC1 PRIMARY KEY ()
    )
GO

GRANT Select ON D3000S.USER_TC1 TO READ01
GO
GRANT Delete ON D3000S.USER_TC1 TO turbocad
GO
GRANT Insert ON D3000S.USER_TC1 TO turbocad
GO
GRANT Select ON D3000S.USER_TC1 TO turbocad
GO
GRANT Update ON D3000S.USER_TC1 TO turbocad
GO
GRANT References ON D3000S.USER_TC1 TO turbocad
GO

vgroch

Member

Re: Edit table data

Also I found out that in Sybase Central there is defined column "COLUMNS" with value "SPID,NO_POLOZKY"

sqldbxhelp

Administrator

Re: Edit table data

It looks that for some reason SqlDbx was not able to extract PRIMARY KEY for this table,
because line CONSTRAINT PK_TC1 PRIMARY KEY () does not look right.
Can you do me a favor. Can you extract DDL for this table in Sybase Central and
send it to support

Last edited by sqldbxhelp (2008-11-15 12:07:59)

vgroch

Member

Re: Edit table data

you got it...

sqldbxhelp

Administrator

Re: Edit table data

Thank you. This issue has been resolved