Zeoslib Portal

FWIW it needs to be considered that Firebird stores uuids big endian so that the typical conversion to TGUID like using PGuid over the byte array and alike will not work and cause similar issue to this one (probably my own workaround I mentioned in my first post suffers from that issue as well): htt...

Why not both? Specify type mapping rules on the connection and on the individual datasets (that's how DevArt does it - see https://blog.devart.com/data-type-mappi ... nents.html)

Zeos should treat CHAR(16) CHARACTER SET OCTETS as ftGuid and not ftBytes similar to FireDAC (see http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Firebird_and_Interbase_Servers_Questions_(FireDAC)) I tested a bit and I think this should be implemented somewhere in ZDbcInterbase6Utils.TZSQLDA.GetFi...

Awesome, thanks

Yes, the change to GetMoreResults is not needed - I updated the diff in my previous comment accordingly

I think you are absolutely right. My first version of the change did take the last resultset and it was always closed because of the following call to GetMoreResults which returned False. Later I decided to take the first and leave the loop. So it could be the change in GetMoreResults is not needed ...

Sure that would be better - however until now even if you did multiple select statements it returned the results from the first. It only raised an exception if the first statement did not return a result set but discarded the following anyway. So I just fixed that by making it possible to return the...

I think this is actually a bug in ZEOS as it cannot handle what the DBMS supports. See https://dev.mysql.com/doc/refman/5.7/en/c-api-multiple-queries.html Here is a patch to enable this functionality (based on 7.1.4-stable) --- ZDbcMySqlStatement.pas +++ ZDbcMySqlStatement.pas @@ -324,8 +324,21 @@ b...

If you are working on Windows 7 64 bit make sure the libmysql.dll is in the windows\syswow64 folder.
You can also copy the file to the Delphi\bin folder.

Thx Michael, That's what we were all waiting for. Unfortunately it does not solve my problem with the StrUtils unit that is not known by Delphi5. Why are the used functions not necessary for the other ZDbc*****ResultSet units? Hi, I have just fixed this bug. The method leftstr is replaced with copy...

Dear users,

now the components TZQuery and TZTable have both support for TZSequence implemented.
Just link a TZSequence-Object to one of them and set SequenceField property to fill this field with TZSequence.GetNextValue if it IsNull when posting.

Regards
Stevie

Hi,

please refer to the MySQL Reference Manual for further information.

Regards
Stevie

Yes, we decided to change this property from RequestLive to ReadOnly. I recommend to use the Tool BKReplaceEm to search and replace any reference in your code (*.pas and *.dfm). Please consider that RequestLive = True is now ReadOnly = False and RequestLive = False is now ReadOnly = True! Please ref...

Why does Lazarus not want to call an abstract method? ...
Ok, I fixed it already...

Dear users,

the Zeos-Team is very interested to know on which databases you work with zeos. Please let us know. If you use multiple databases, please choose your favorite.

Regards