Search found 4 matches

by napi
13.03.2007, 05:05
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: EDatabaseError with message Field 'xxxxxx' must have a value
Replies: 7
Views: 1793

hi bangfauzan, mdaems Yes, i understand now. I follow your example and it's work. Just set required to False. exp tblQuestion.FieldByName('ID_SIMPAN').Required := false; tblQuestion.append; tblQuestion.FieldByName('ID_MS').asInteger := 1; tblQuestion.FieldByName('NAMA').asString :='Test'; tblQuestio...
by napi
12.03.2007, 01:34
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: EDatabaseError with message Field 'xxxxxx' must have a value
Replies: 7
Views: 1793

hi mdaems below is my table structure /* table structure */ CREATE TABLE "SIMPAN" ( "ID_SIMPAN" INTEGER NOT NULL, "ID_MS" VARCHAR(10) CHARACTER SET WIN1251, "NAMA" VARCHAR(100), PRIMARY KEY ("ID_SIMPAN") ); /* Triggers */ CREATE TRIGGER "BI_SIMP...
by napi
08.03.2007, 07:38
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: EDatabaseError with message Field 'xxxxxx' must have a value
Replies: 7
Views: 1793

Hi,

That field is primary key and default set to 'not null' in firebird. How ever your solution is work when i remove primary key parameter.

Is there any solution which don't require to remove primary key.?
by napi
05.03.2007, 02:41
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: EDatabaseError with message Field 'xxxxxx' must have a value
Replies: 7
Views: 1793

EDatabaseError with message Field 'xxxxxx' must have a value

hi buddy,

I was install Zeos 6.6.1 beta to replace 6.1.5 version in my application. How ever, i get an error above when inserting new record.

FYI, i'm using firebird database with generator and trigger. It seem trigger does'nt work in version 6.6.1.