[fpc-pascal] Postgresql interface bronken for Raspberry pi model 1b

Björn Lundin b.f.lundin at gmail.com
Mon Mar 28 15:12:58 CEST 2016

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.Params.ParamByName('INT').AsInteger := 1;
 Q2.Params.ParamByName('FT').AsFloat := 2.3;
 Q2.Params.ParamByName('DT').AsString := '2016-03-23 12:12:12.123';

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 at raspberrypi ~/svn/bnlbot/botstart/bot-1-0/source/pascal $ ls -la
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.


More information about the fpc-pascal mailing list