Zeoslib Portal

EgonHugeist , I am not sure about PQdescribePrepared also, but docs say The functions PQnparams and PQparamtype can be applied to this PGresult to obtain information about the parameters of the prepared statement If somebody assigns this param with AsString := '123' we can add a parametertype text ...

EgonHugeist , Oleg, i was running into the same issue with such selects: Query.SQL.Text := 'select :test'; if PostgreSQL can't determine the Field for the Parameter then we got the same Exception. So i was forced keeping the emultated prepared as default again. Hmpff. I was thinking about it. The o...

EgonHugeist,

I think complete absence of support is a bigger problem. Besides, implementing MySQL's CallableStatement, can lead to some global changes we'll have to make.

EgonHugeist, miab3,

Patch for Firebird's parameters order is done (rev.1689).

EgonHugeist , if I remember right, Firebird has separate lists for in and out parameters, so there is no 'right' order for combination of them ( miab3 , maybe you can tell better?) All the other databases, especially those supporting InOut params! have defined order. Do you know if such double nami...

EgonHugeist,

I looked at other drivers and as I can see, only Interbase creates outparams before inparams.
PG returns only returnValue at the beginning of the list.

So it looks like there won't be much work to implement new behaviour.

EgonHugeist,

So i propose to add a temporary define for the new behavior you plan (the correct one in my mind).

agree. And what about testcases, should I add define to them too or just test the new behaviour?

miab3 , EgonHugeist , don't you think parameters should go in order they appear in function declaration? Params[0] -> P1 Params[1] -> P2 Params[2] -> P3 Params[3] -> P4 Params[4] -> P5 And what about returnValue? I think (if there is such param) it also has to be at the end of parameter list. What ...

sfxcc,

as for now you can implement Application.OnException handler and show messages in there.
(But I think this can be implemented)

wylton,

maybe you should try http://wiki.freepascal.org/Zeos_tutorial (at the end of the page)

EgonHugeist , Done with parameter names. Here is how it works: if PG version is < 8.0, then params are still named $0, $1 and so on (I couldn't find the way to retrieve names for older versions). on PG 8.0+ Parameter names are retrieved, unnamed params' names are empty strings. But there is one exc...

EgonHugeist,

Yes

EgonHugeist,

According the names Parameters: Yes it word be a good choice to return the $x name for unnamed params but the real name for named once.

Well actually I was talking about leaving unnamed params without a name (an empty string '').

miab3,

can't test it myself on FireBird, but shouldn't P1 be Param #1?

EgonHugeist , If you felt motivated then it would be fince to have this posibility. I felt motivated when started that other topic . But after going deeper I understood that PostgreSQL's implementation of TZStoredProc is just a "stub" and has to be completely rewritten. There are troubles...