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

2021-03-10 Thread Toru Takubo via fpc-pascal
On 2021/03/10 16:07, Florian Klämpfl via fpc-pascal wrote: Am 10.03.2021 um 04:59 schrieb Toru Takubo via fpc-pascal : Can you please post the output of -va of the arm compiler and provide some information about the arm system you are using? The output message with -va option can be dow

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

2021-03-10 Thread Toru Takubo via fpc-pascal
On 2021/03/10 15:29, LacaK via fpc-pascal wrote: Dňa 9.3.2021 o 15:34 Toru Takubo via fpc-pascal napísal(a): On 2021/03/09 18:11, LacaK via fpc-pascal wrote: I did run test program on RaspberryPI: Linux+ARM and results are as expected. (FPC 3.2.0) -Laco. My compiler setting is below. Does s

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

2021-03-10 Thread Cappelletto Gabriele via fpc-pascal
It happened to me with firebird too. Same mistake. 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 writ

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

2021-03-09 Thread Florian Klämpfl via fpc-pascal
> Am 10.03.2021 um 04:59 schrieb Toru Takubo via fpc-pascal > : > >> Can you please post the output of -va of the arm compiler and provide some >> information about the arm system you are using? > > The output message with -va option can be downloaded from below. > > http://support.e-parcel.

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

2021-03-09 Thread LacaK via fpc-pascal
Dňa 9.3.2021 o 15:34 Toru Takubo via fpc-pascal napísal(a): On 2021/03/09 18:11, LacaK via fpc-pascal wrote: I did run test program on RaspberryPI: Linux+ARM and results are as expected. (FPC 3.2.0) -Laco. Thank you for your reproduction test. It may be a good news that the problem would n

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

2021-03-09 Thread Toru Takubo via fpc-pascal
On 2021/03/10 5:40, Florian Klämpfl via fpc-pascal wrote: Am 09.03.21 um 01:47 schrieb Toru Takubo via fpc-pascal: On 2021/03/08 16:54, Michael Van Canneyt via fpc-pascal wrote: On Mon, 8 Mar 2021, Toru Takubo via fpc-pascal wrote: Hi, I am developing my app on Windows and building apps fo

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

2021-03-09 Thread Florian Klämpfl via fpc-pascal
Am 09.03.21 um 01:47 schrieb Toru Takubo via fpc-pascal: On 2021/03/08 16:54, Michael Van Canneyt via fpc-pascal wrote: On Mon, 8 Mar 2021, Toru Takubo via fpc-pascal wrote: Hi, I am developing my app on Windows and building apps for other platforms by using cross compiler. Now I have a pro

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

2021-03-09 Thread Toru Takubo via fpc-pascal
On 2021/03/09 18:11, LacaK via fpc-pascal wrote: I did run test program on RaspberryPI: Linux+ARM and results are as expected. (FPC 3.2.0) -Laco. Thank you for your reproduction test. It may be a good news that the problem would not be in the compiler but around configuration or environment.

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

2021-03-09 Thread LacaK via fpc-pascal
I did run test program on RaspberryPI: Linux+ARM and results are as expected. (FPC 3.2.0) -Laco. Dňa 9.3.2021 o 1:47 Toru Takubo via fpc-pascal napísal(a): On 2021/03/08 16:54, Michael Van Canneyt via fpc-pascal wrote: On Mon, 8 Mar 2021, Toru Takubo via fpc-pascal wrote: Hi, I am develo

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

2021-03-09 Thread Michael Van Canneyt via fpc-pascal
On Tue, 9 Mar 2021, Toru Takubo via fpc-pascal wrote: thank you for the test program. I tested on linux 64-bit, that works OK too. When you look in the database on the arm machine  with an sqlite tool, do you see the correct values or are the inserted values wrong ? (I'm trying to establ

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

2021-03-09 Thread Toru Takubo via fpc-pascal
On 2021/03/09 17:07, Michael Van Canneyt via fpc-pascal wrote: On Tue, 9 Mar 2021, Toru Takubo via fpc-pascal wrote: I don't know what to advise to further investigate the issue, One thing to try would be to test whether normal float arithmetic or date arithmetic works. If not, then the compi

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

2021-03-09 Thread Gabriele Cappelletto via fpc-pascal
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

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

2021-03-09 Thread Michael Van Canneyt via fpc-pascal
On Tue, 9 Mar 2021, Toru Takubo via fpc-pascal wrote: I don't know what to advise to further investigate the issue, One thing to try would be to test whether normal float arithmetic or date arithmetic works. If not, then the compiler people will need to give more advice. I created a simpl

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

2021-03-08 Thread Toru Takubo via fpc-pascal
On 2021/03/08 16:54, Michael Van Canneyt via fpc-pascal wrote: On Mon, 8 Mar 2021, Toru Takubo via fpc-pascal wrote: 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 c

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

2021-03-07 Thread Michael Van Canneyt via fpc-pascal
On Mon, 8 Mar 2021, Toru Takubo via fpc-pascal wrote: 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/writ

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

2021-03-07 Thread Toru Takubo via fpc-pascal
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