[fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b
Michael Van Canneyt
michael at freepascal.org
Mon Mar 28 13:45:48 CEST 2016
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.
More information about the fpc-pascal
mailing list