mORMot Open Source

VojkoCendak

Member

From: Celje Slovenia

Registered: 2012-09-02

Posts: 88

SQLite3 DB TModTime problem

(Delphi 2009 ent)
We found that when we Save to db field TModTime with Iso8601FromDateTime(Now+OneSec),actual seconds do not increment in db field. It's kind of constant ?
And reverse Iso8601ToDateTime is not working. I mean DateTime is not equal.

thank you,
Vojko

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,238

Website

Re: SQLite3 DB TModTime problem

As stated by the documentation, TModTime fields are re-computed on the fly by the ORM before sending the updated CRUD request to the server.

So the values you put manually in TModTime will be overriden on the client side.

If you want to set a special value, do not use a TModTime field, but a basic TTimeLog kind of property.
You may also use low-level SQL to do it, but it is a hack, not ORM friendly.