Zeoslib Portal

Please send the patches if you did it to your sources already. Quite limited in programming time for the moment. Sorry. Reading the forum is possible, programming and testing is difficult. I'll write it onmy todo list in case we forget... I'll commit it when I get it. Mark Done!! Mark I have sent y...

Hi Mark.
As always great job !!!. Sorry for the confusion.

regards

@all: Hi! Using D2006 - Enterprise Edition (ger.) - Version: 10.0.2288.42451 Update 2 (also applied the Hotfixes) and solved the problem like this (thx to Mark for the hint!). @Mark: Had diverse probs using your "@"-Version ;-) [syntax="delphi"]destructor TZMySQLNativeLibraryLoa...

Mdaems is right. Your query is not a small nor medium. 70,000 will surely slow down a lot. If you need to do searches is better to filter the query or limit the query by Adding a "LIMIT nnn" at the end of SELECT statement, where nnn is the max of records to obtain from the resulting query ...

You need to download latest SVN 103 version. and go to post http://zeos.firmos.at/viewtopic.php?p=3220#3220 in user contribution section where what you need is explained, also there is a demo for the embedded server, but you need to download latest SVN version because it uses libmysql41d.dll contain...

When you call RecordCount TZQuery will bring to the client machine all the records resultig from the server. that what it will slow a little, but only in the line where you call recordcount, after that line all works because all records are now in the client's memory. For your code there no other so...

You can try revision 98, that nwas the last posted here in the forum. We 're now in revision 103, that ahs added functionality to mysql for myembedded server and some new events. it seems to work fine for me. but maybe bugs can appear, but in normal functionality there si no problem with rev 103.

Well I'm working correctly with this kind of queries and i dont' have this type of errors. what mysql client dll are you usign and what version of mysql you're using. because it seems here all works fine.

Hi try to use the TZUpdateSQL object, it has now a property refreshSQL where you can add this kind of sql, TZUpdateSQL have to be attached to the TZQuery or tztable. try to download at least revision 98 of zeosdbo version, it is now published here and have this property.

Also I'm attatching a demo for using embedded server, mabe it can be adapted to be ageneric example for using an embedded server. You need either libmysqld41.dll or libmysqld50.dll to run the demo.

Hi Mark and tohenk I have applied tohenk's modifications to revision 101. With 4.1 seems to work ok :D at first Misteriously i have some problems working with embedded 5.0 at first, but now seems to work ok, very, very strange. :shock: For Notes to the documnetation, embedded server needs the follow...

Hi Finally some did what i was trying to do time ago, I'm happy to hear about it. Mark I will try to apply the changes and check if it works ok, then i will make the patch for latest revision and send it to you. Thanks tohenk, and do you have any valid Embedded server dll for mysql 5.0?. can you sen...

it occurs at the moment it connects. I have traced the error at ZPlainMySQLdriver at line 2609 in Function function TZMySQL41PlainDriver.SetOptions(Handle: PZMySQLConnect; Option: TZMySQLOption; const Arg: PChar): Integer; begin Result := MYSQL_API.mysql_options(Handle, ZPlainMySql41.TMySqlOption(Op...

Hi does any have tried to use the mysql embdded protocol that is now included in zeos, i have tried to work with it but i could not have any success. it trhows an "access violation error in libmyd41.dll" or access violation error in libmysqld50.dll.
Does anyone?

I think i have found the error. It has to be with a function GetCachedResulset located at ZDBCInterbase6Utils.pas, when the CachedResultset is created, the param for the NativeResolver is set as Nil, thats why it gives the problem. so the function function GetCachedResultSet(SQL: string; Statement: ...