Zeoslib Portal

miab3,

I guess you're right. Methods declared in public interface shouldn't be implemented as private.

Btw, why is it in interface at all?

EgonHugeist,

I added a testcase for TestStandartConfirmingStrings (rev. 1625). It fails now besause of quotes I asked about.

EgonHugeist , I fixed QuoteState tokenizer, added support for nested comments in CommentState, added some tests. I also had to remove backslash_quote processing, because it has no effect neither on tokenizing nor on escaping. Now I have 2 questions: First is about GetEscapeString. Strings starting ...

Also do i wonder about "Bit" and "varbit". Are they right interpreted?

Yes, they are just strings of 1's and 0's

EgonHugeist,

But the i got terrible results with the Test-Suites

It happened because of quotting string two times. GetEscapedString applies AnsiQoutedString to result of EncodeString, but EncodeString already added quotes around it.

EgonHugeist,

Yes, it's clientencoding dependent.

did you setup our testsuites?

I'll do it tonight.

EgonHugeist,

Yes, they depend on ClientEncoding.

Btw, there's bug in rev 1600.

EgonHugeist,

In PostgreSQLToSQLType(oid and typename version) bpchar(oid=1042) should be treated as char

The problem is back.

EgonHugeist , I don't think so. All database special things are easy to handle with the TZConnection.Properties. There i already introduces the Standart_Confirming_Strings value. ): You're right about TZConnection.Properties. But methods I proposed are made for getting and setting current run-time ...

Ok, I'll try. The first step would be retrieving current standard_conforming_strings setting from the server instead of relying on server version. I also introduced 2 convinience methods for TZPostgreSQLConnection: GetServerSetting & SetServerSetting. I'm not familiar with other drivers, so mayb...

EgonHugeist , What's that for a hack? (; Just something like OutputParamValues[0] := GetPlainDriver.GetValue(QueryHandle, 0, 0); in Statement's update method Can you explain me why did you change it? Well, CreateResultSet returns NativeResultSet instead of CachedResultSet when Statement has ResultS...

EgonHugeist , OK, forget about it. Here is reason why we use TZStoredProcedure at all. We use AutoCommit = True. I need to execute procedure and get it's returnValue. TZQuery.ExecSQL commits transaction but doesn't return a value. TZQuery.Open allows to get out data, but doesn't Commit transaction....

EgonHugeist,

I see. But ASA, Interbase and Oracle drivers do fetch out params. May be Project Manager could accept patches to support ONLY out params (w/o resultsets) for PostgreSQL?

EgonHugeist,

I thought procedures can have both UpdateCount and ResultSet same time, don't they?