Search found 2 matches
- 22.02.2008, 23:27
- Forum: Other 6.x Versions
- Topic: Postgresql out argument for parameters in functions
- Replies: 2
- Views: 3353
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...
- 18.02.2008, 14:51
- Forum: Other 6.x Versions
- Topic: Postgresql out argument for parameters in functions
- Replies: 2
- Views: 3353
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...