Recent

Author Topic: Error message from TSQLQuery: Field TimeModified is required but not supplied.  (Read 488 times)

Nomos

  • New member
  • *
  • Posts: 8
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][+][-]
  1. "Project MyProject released Exception Class "EDataBaseError" with Message:
  2. 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

  • New Member
  • *
  • Posts: 12
NOT NULL means it needs a value.

Is it NOT NULL in the SHARES table?

 

TinyPortal © 2005-2018