Search found 2 matches

by SiegfriedN
22.02.2008, 23:27
Forum: Other 6.x Versions
Topic: Postgresql out argument for parameters in functions
Replies: 2
Views: 3289

solution

Hi, Postgres returns out parameters as a resultset thus the following returns the out parameter values from the server. Instead of calling ExecSQL use the Open method of TZQuery. All the out parameters are then returned in one field seperated by commas. i.e. query.Fields[0].Value e.g. '('text1',1234...
by SiegfriedN
18.02.2008, 14:51
Forum: Other 6.x Versions
Topic: Postgresql out argument for parameters in functions
Replies: 2
Views: 3289

Postgresql out argument for parameters in functions

Hi, How does one get the value returned into a Postgresql 'out' function parameter with Zeoslib? For example. Postgres function 'create or replace function test1(in varchar, in char, out varchar); ..etc When calling the function from a TZQuery SQL.Text := 'select test1(:par1, :par2)'; ..etc This wor...