distal-attribute
distal-attribute
distal-attribute
distal-attribute

Random columns appear on columns editor (The column not belong to the table)

aswzen posted 11 months ago in General

see the image for explanation..

what are they?

im using heidi sql 9.4.0.5125 (64bit)

1 attachment(s):
  • errork
hakuno posted 11 months ago

Update to 9.4.0.5138

Check it out.

aswzen posted 11 months ago

already updated to 5138 still error for sure

and every time i open the data tab, this error pops out

1 attachment(s):
  • pok
ansgar posted 11 months ago

If you post the contents of the CREATE TABLE tab here, I can probably fix what is wrong here.

aswzen posted 11 months ago
CREATE TABLE "TR_WO_ITEM" (
    "ROW_ID" INT NOT NULL,
    "WO_NO" VARCHAR(15) NOT NULL,
    "REVISION_NO" INT NOT NULL,
    "ITEM_ID" VARCHAR(10) NULL DEFAULT NULL,
    "ITEM_PACKAGE_TYPE_ID" CHAR(1) NULL DEFAULT NULL,
    "QTY_REQUIRED" INT NULL DEFAULT NULL,
    "QTY_STOCK" INT NULL DEFAULT NULL,
    "QTY_LOAN" INT NULL DEFAULT NULL,
    "QTY_RENT" INT NULL DEFAULT NULL,
    "QTY_PURCHASE" INT NULL DEFAULT NULL,
    "ITEM_REMARKS" VARCHAR(500) NULL DEFAULT NULL,
    "LOGISTIC_STATUS_ID" VARCHAR(5) NULL DEFAULT NULL,
    "LOGISTIC_REMARK" VARCHAR(255) NULL DEFAULT NULL,
    "PARENT_ITEM_ID" VARCHAR(10) NULL DEFAULT NULL,
    "SOURCE_ITEM_ID" VARCHAR(10) NULL DEFAULT NULL,
    "ITEM_TYPE_FLAG" CHAR(1) NULL DEFAULT NULL,
    "ITEM_ALIAS_ID" VARCHAR(10) NULL DEFAULT NULL,
    "REQUEST_PIC_CREW_ID" VARCHAR(10) NULL DEFAULT NULL,
    "ITEM_MOVEMENT_CHECK" VARCHAR(1) NULL DEFAULT 'N',
    "RELEASE_FLAG" VARCHAR(1) NULL DEFAULT NULL,
    "QTY_CHECK_OUT" INT NULL DEFAULT NULL,
    "LOGISTIK_RECOMENDATION" VARCHAR(50) NULL DEFAULT NULL,
    "IF_CI" NCHAR(1) NULL DEFAULT NULL,
    "IS_TRANSFER" NCHAR(1) NULL DEFAULT NULL,
    "REPLACEMENT_FLAG" NCHAR(1) NULL DEFAULT NULL,
    "WO_ITEM_REPLACED" VARCHAR(10) NULL DEFAULT NULL,
    "IS_ITEM_SET" NCHAR(1) NULL DEFAULT NULL,
    "IS_ITEM_ADDED" NCHAR(1) NULL DEFAULT NULL,
    PRIMARY KEY ("ROW_ID"),
    UNIQUE INDEX "UNIQUE" ("WO_NO", "ITEM_ID", "ITEM_ALIAS_ID", "PARENT_ITEM_ID")
);

created on MSSQL Database Manager

ansgar posted 11 months ago

Ok, that code is created by HeidiSQL internally, and produces errors. I cannot reproduce that issue without having the same table structure here. So, is there any reliable way in MSSQL to get the CREATE code for a table?

aswzen posted 11 months ago

try to reproduce the error, i found something in heidi table editor like this one heidisql .com/ forum.php ?t=22194

  1. Table already created
  2. open table editor
  3. add unique key to a column
  4. save
  5. error pops out
1 attachment(s):
  • error
aswzen posted 10 months ago

how its going?

Please login to leave a reply, or register at first.