[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