Re: [fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b

2016-04-03 Thread Björn Lundin
On 2016-04-02 20:29, Bo Berglund wrote: > On Mon, 28 Mar 2016 15:30:36 +0200, Björn Lundin > wrote: > >> That speaks for trying to compile 3.0.0. >> The pi is on wheezy, so there is no .deb package >> for it. > > I made a script for installing FPV 3.0.0 and Lazarus 1.6

Re: [fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b

2016-04-02 Thread Bo Berglund
On Mon, 28 Mar 2016 15:30:36 +0200, Björn Lundin wrote: >That speaks for trying to compile 3.0.0. >The pi is on wheezy, so there is no .deb package >for it. I made a script for installing FPV 3.0.0 and Lazarus 1.6 release on an RPi.

Re: [fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b

2016-03-28 Thread Björn Lundin
On 2016-03-28 15:02, Marco van de Voort wrote: > There are like 250+ database fixes since 2.6.0. That speaks for trying to compile 3.0.0. The pi is on wheezy, so there is no .deb package for it. Thanks -- Björn ___ fpc-pascal maillist -

Re: [fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b

2016-03-28 Thread Björn Lundin
On 2016-03-28 13:45, Michael Van Canneyt wrote: > I don't think the problem is in the SQLDB code, it is CPU-agnostic. Hmm, real strange I chagne the code like this Q2 := CreateQuery(T) ; sSql := 'insert into TEST values (:INT, :FT, :DT)'; Q2.SQL.Text := sSql; Q2.Prepare;

Re: [fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b

2016-03-28 Thread Marco van de Voort
In our previous episode, Michael Van Canneyt said: > > Changing the line to > > > > Q2.Params.ParamByName('DT').AsDateTime := now; > > I don't think the problem is in the SQLDB code, it is CPU-agnostic. There are like 250+ database fixes since 2.6.0.

Re: [fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b

2016-03-28 Thread Björn Lundin
On 2016-03-28 13:45, Michael Van Canneyt wrote: > > I don't think the problem is in the SQLDB code, it is CPU-agnostic. > Hmm, ok. I'm looking at the sqldb code, and I'll need some time to digest it. Meanwhile, I think I'll try using the PQConnection unit directly, to see if I get the same

Re: [fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b

2016-03-28 Thread Michael Van Canneyt
On Mon, 28 Mar 2016, Björn Lundin wrote: On 2016-03-28 10:27, Michael Van Canneyt wrote: On Mon, 28 Mar 2016, Björn Lundin wrote: However I'm running into trouble on timestamps fields on the pi. [snip] Q2.Prepare; //Q2.Params.ParamByName('DT').DataType := ftDateTime;

Re: [fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b

2016-03-28 Thread Björn Lundin
On 2016-03-28 10:27, Michael Van Canneyt wrote: > > > On Mon, 28 Mar 2016, Björn Lundin wrote: >> However I'm running into trouble on timestamps fields on the pi. > > [snip] > >> Q2.Prepare; >> //Q2.Params.ParamByName('DT').DataType := ftDateTime; >> Q2.Params.ParamByName('DT').Value :=

Re: [fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b

2016-03-28 Thread Michael Van Canneyt
On Mon, 28 Mar 2016, Björn Lundin wrote: Hi! I'm using a pi as a monitor for some process, so I'm trying to get SDL2 and a working postgres interface on it. However I'm running into trouble on timestamps fields on the pi. [snip] Q2.Prepare; //Q2.Params.ParamByName('DT').DataType :=

[fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b

2016-03-28 Thread Björn Lundin
Hi! I'm using a pi as a monitor for some process, so I'm trying to get SDL2 and a working postgres interface on it. However I'm running into trouble on timestamps fields on the pi. I wrote a console program on Win7, using 32-bit compiler bundled with Lazarus 1.6. (I think is is fpc 3.0.0) and