[fpc-pascal]interbase

[stingp1.eti at mail.cez.cz]

>I want to mix (under linux) the vantage of UnCGI & Interbase unit, but the
result is a weird error >message. Maybe this is not the good place for this
question, but i can't find the solve of this >problem.
>
>Here the error message:
>
>Connecting to testdb.gdb: OK. Starting Transaction : OK. Allocating statement :
OK. Preparing statement >: Failed: <- This is the problem.

If you have sources of FPC, try the object wrapper of ibase units, it's located
in
fcl/db/interbase dir in development tree. Here is workaround, which show you
server error messages,
so you can better discover what's wrong with it. I can also send you most recent
units,
or you can download fcl.zip sources from main download tree.

>
>// Write ('Preparing statement : '); if
ISC_dsql_prepare(@status, at ta, at statement,0,query,1,sqlda)<>0 >then
>
>(sources: testib.pp, uncgi.pp, ibase60.pp)
>

Prepare can fail for many reasons, bad SQL statement, transaction error or so...

--------------------------------
Pavel Stingl
mailto: stingp1.eti at mail.cez.cz
--------------------------------