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

[expired user #10336]'s profile image [expired user #10336] posted 7 years ago in General Permalink

see the image for explanation..

what are they?

im using heidi sql 9.4.0.5125 (64bit)

1 attachment(s):
  • errork
[expired user #10326]'s profile image [expired user #10326] posted 7 years ago Permalink

Update to 9.4.0.5138

Check it out.

[expired user #10336]'s profile image [expired user #10336] posted 7 years ago Permalink

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's profile image ansgar posted 7 years ago Permalink

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

[expired user #10336]'s profile image [expired user #10336] posted 7 years ago Permalink
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's profile image ansgar posted 7 years ago Permalink

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?

[expired user #10336]'s profile image [expired user #10336] posted 7 years ago Permalink

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
[expired user #10336]'s profile image [expired user #10336] posted 7 years ago Permalink

how its going?

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