Zeoslib Portal

Ok, thank You, Jan, I will check out (probably the next days) and try it.

with best regards
Andreas

Thank You, Jan !

For the moment (in that case) I can do "<Query>.Close", then "<Query>.Open", but if Refresh will work, it would by fine.

with best regards
Andreas

Hello Jan, I could reduce the problem to the following : - (with SQL) : "create table refreshdata (no Integer, info_data Char (50))" - (with SQL) : "insert into refreshdata values (1, 'info 1')" - create a delphi project with ZConnection to the database and ZQuery - ZQuery.SQL.Te...

Hello (again...), maybe it's helpfull : the query with the refresh-problem has an "AfterOpen"-Event, this event changes display-labels, adds "OnGetText"-Events to some fields and - this is some how the problem - changes the index (FieldByName ('XY').Index := n). Without changing ...

Hello again, and the best wishes for the new year ! some time ago, I posted about the problem with "refresh"; meanwhile I had the chance to test again, therefore I checked out the version 7.2 (SVN revision 3892). First : the problem seems to be the same (unit ZDatasetUtils, "FetchFrom...

Hello Jan,

I just checked out 7.2 and will do some test.

Thank You,
best regards
Andreas

Hello, in Delphi 7 and Zeos 6.5.1 I often use "<ZQuery>.Refresh" to refresh the data displayed, for example in a DBGrid (Database is PostgreSQL 8.4). After changing to Delphi XE 10, Zeos 7.14 and PostgreSQL 9.5, I have some problems doing this again. Debugging leads to the unit "ZAbst...

Hello (again), after doing some experiments with "direct" access (using "PGconnect" etc. from libpq.dll) I was able to get the right error-message: after changing "client_encoding" from "LATIN1" to "UTF-8" the correct message is displayed. :oops: I'm...

Hello, I'm using Zeos 7.1.4 stable with Delphi XE 7 and Postgres 9.4; when there is an error (SQL-Syntax or other), I always get ' "SQL Error: ERROR: character with byte sequence ... in encoding "UTF8" has no equivalent in encoding "LATIN1" '. The message is generated by &qu...

Thank You, Michal,

I will check this.

with best regards
Andreas

Hello, in the unit "ZCompatibility" there is the function "hash" - for some values this function gives an exception (integer overrun). My system : Windows 8.1 (64 Bit), Delphi XE6, Zeos 7.1.3a, build target is 32 Bit The problem will, for testing, occure when passing a string of ...

Hi,

Thank You for the patch, it is very helpfull for me.

With best regards
Andreas

Hello, in some situation there seems to be a problem in the function mentioned above : ... stInteger: Result := PInteger(ValuePtr1)^ - PInteger(ValuePtr2)^; ... the "old" value in my integer-column is somewhat with 3.000.000, the new one is about -2.147.480.000. Both values are inside the ...

Maybe, someone uses even older versions of Postgresql, then the "if" should be like

if (Connection.GetServerMajorVersion < 7) or((Connection.GetServerMajorVersion = 7) and (Connection.GetServerMinorVersion < 3))

But it works fine for my needs,

Thank You, best regards
Andreas

Thanks for the information; seems to be changed from 32 to 64 Byte with PostgrSQL-version 7.3 (documentation for 7.2 says 32 Byte, documentation for 7.3 has 64 Byte).

Regards
Andreas