Error message from TSQLQuery: Field TimeModified is required but not
supplied.
lazarus / 63-Database

----------------------------------------------------------------------
Nomos · 2020-05-01 22:51

Lazarus 2.08
Windows 10
SQLite

Hello, everyone.

I am currently creating a small application with Lazarus 2.08, based
on SQlite.

There are two tables (Members, Shares) in SQLite with an 1:n relation.
In both
tables is a datafield

TimeModified     TIMESTAMP CONSTRAINT [CURRENT_TIMESTAMP] NOT NULL
DEFAULT (CURRENT_TIMESTAMP)

This datafield isn't used within the application.

But the behavior is different:

Appending a record to the table SHARES everything is fine. Appending a
new record to MEMBERS I receive
an error message:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i "Project
MyProject released Exception Class "EDataBaseError" with
Message:queryMembers: Field TimeModified is required but not
supplied."
Maybe the message is slightly different when using the IDE in english.
I translated the message from german.

Somebody out there who can give me a hint what to do?

Regards

----------------------------------------------------------------------
chuckles1066 · 2020-07-06 10:32

NOT NULL means it needs a value.

Is it NOT NULL in the SHARES table?