Search found 140 matches

by trupka
13.04.2008, 21:57
Forum: PostgreSQL
Topic: Two simple troubles for PG newbee
Replies: 2
Views: 1087

1.) paramByName works fine for me (pg8.2, Zeos 6.6.3-rc, Delphi7). Can say same for Interbase / Firebird.
2.) Maybe Zquery1.fields[1].value is what you seeking for ?
by trupka
13.04.2008, 21:46
Forum: PostgreSQL
Topic: Delphi7 and Stored Procedures
Replies: 6
Views: 4128

Don't understand... your function returns (set of) array type or you have one or more fields inside result set which are array type or ...?? Some more detailed example would be useful, php is fine.
by trupka
28.03.2008, 11:39
Forum: PostgreSQL
Topic: Zeos in TService
Replies: 7
Views: 1591

Wild_Pointer - I don't have useful test project but I can send you "real" service application with removed unnecessary parts. Just give me few hours...
by trupka
28.03.2008, 09:41
Forum: PostgreSQL
Topic: Zeos in TService
Replies: 7
Views: 1591

Works fine with me (D7, pgslq8.1 and 8.2) with DLLs in Windows\System32 directory but, some time ago, I encountered machines with invalid / broken ssleay32.dll and libeay32.dll which caused me similar problem. I "discovered" it because they have too high version numbers, like 1.x.x.x. Mayb...
by trupka
20.01.2008, 22:27
Forum: PostgreSQL
Topic: Delphi7 and Stored Procedures
Replies: 6
Views: 4128

Don't use ZstoredProc component, use Query component and "embed" stored procedure into SQL eg. ZReadOnyQuery.SQL := 'select * from storedproc(:param1)'; ZReadOnyQuery.paramByName('param1').value = 1; ZReadOnyQuery.Open; If Your postgres stored proc returns set then use above SQL. If return...