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.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
