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;
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.
Thanks for the reply.
Unfortuantly, it does not help.
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.
Michael.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal