On 2016-03-28 13:45, Michael Van Canneyt wrote:
> I don't think the problem is in the SQLDB code, it is CPU-agnostic.
Hmm, real strange
I chagne the code like this
Q2 := CreateQuery(T) ;
sSql := 'insert into TEST values (:INT, :FT, :DT)';
Q2.SQL.Text := sSql;
Q2.Prepare;
Q2.Params.ParamByName('INT').AsInteger := 1;
Q2.Params.ParamByName('FT').AsFloat := 2.3;
Q2.Params.ParamByName('DT').AsString := '2016-03-23 12:12:12.123';
Q2.ExecSql;
and I get
An unhandled exception occurred at $00030200 :
EDatabaseError : : Unknown fieldtype for parameter "INT".
that is, it has nothing to do with timestamps.
On the ame machine a pythön script is runnig, quering the same database,
with no problem. So I _think_ the client installation of pg is ok.
pi@raspberrypi ~/svn/bnlbot/botstart/bot-1-0/source/pascal $ ls -la
/usr/lib/libpq.so
lrwxrwxrwx 1 root root 12 May 31 2015 /usr/lib/libpq.so -> libpq.so.5.4
However, I'm not sure how to proceed.
Perhaps use fpc 3.0, that is download and compile it ?
I'll see if I find some intructions online for doing that.
--
--
Björn
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
