[fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b
Michael Van Canneyt
michael at freepascal.org
Mon Mar 28 10:27:03 CEST 2016
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 := ftDateTime;
> Q2.Params.ParamByName('DT').Value := now; <----Here
> Q2.ExecSql;
Don't use Value for parameters.
Always use .AsDateTime or whatever the actual type is supposed to be.
Michael.
More information about the fpc-pascal
mailing list