Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Problem with DEFUALT constraint in SQLITE

azielnik's profile image azielnik posted 2 months ago in General Permalink

Hi,

When executed:

CREATE TABLE C ( id INTEGER PRIMARY KEY, store_code TEXT DEFAULT "store1" NOT NULL, name TEXT);

The HeidiSQL lost DEFAULT in definition althought it work unintentionally. When you enter new record, the field not seems to be DEFAULT, and you may put there something. If you leave it blank, and accept the record, then DEFAULT value appears.

In Heidi: CREATE TABLE "C" ( "id" INTEGER NOT NULL, "store_code" TEXT NOT NULL, "name" TEXT NULL, PRIMARY KEY ("id")); althought it works in the above way.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.