[fpc-pascal] Cannot write datetime field on sqlite3 database on ARM

[Gabriele Cappelletto]

It happened to me with Firebird too. Only that the error gave it to me 
in reading, that is db.fieldByName ('cc'). AsDateTime

Il 08/03/21 02:31, Toru Takubo via fpc-pascal ha scritto:
> Hi,
>
> I am developing my app on Windows and building apps for other
> platforms by using cross compiler. Now I have a problem only
> occurred on Linux ARM.
>
> The problem is that it cannot write datetime field on sqlite3
> database. It can read/write other fields like int, varchar
> or blob, but always write zero in datetime (maybe float as well)
> field.
>
> Does anyone have an idea about this issue? I am not sure it is
> fpc issue, but better to report bug?
>
> My observations are as follows:
>
> 1. I work with Lazarus 2.0.12/FPC 3.2.0 release version.
> 2. Target machine is Raspberry Pi OS on Raspberry Pi 3 Model B V1.2.
> 3. My app consists of sqlite3conn and sqldb unit.
> 4. The problem occurred on Linux ARM. It does NOT on Windows i386/x86_64,
>  Linux i386/x86_64 and Linux AArch64.
> 5. I installed "DB Browser for SQLite" on Raspi as a reference. It can
>  write datetime field normally. My app can read it.
>
> Toru
>
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal