Zeoslib Portal

Hi Anse, Maybe you should check where he's changing the current database to Information_schema. Quick scanning, the code information_schema is only used in PostGresSql.My patch concerns mysql only. If you find the solution, please send a patch to the testing SVN branch for zeoslib. So we can integra...

Hi AHUser, I applied your patch to the (new) testing branch in the SVN repository. This branch is the development branch to avoid disturbing the trunk 'production' branch. As a contributer I propose you change to the testing branch. It would be nice if you could go on modifying the other units, not ...

Hi MParak, Shame on me... Yesterday I read some article on PlanetMysql concerning tunneling a mysql connection. I don't know wether you already have solved the problem, but there's a good paragraph in the mysql online documentation addressing your problem. http://dev.mysql.com/doc/refman/5.0/en/wind...

Hi, AHUser.

I've just applied your patch. It doesn't seem to give trouble in D7. The testsuite didn't give more problems than before either. So, I would advise others to give it a try on other platforms.

Firmos, would you do the integration?

Mark

Hi, I think you're right. BUT: * Do the other compilers support it? If not you should make sure it's commented out for the other compilers. * You may start patching the modules one by one. I would propose you start with the Core units. Negative reactions will come pretty soon if there might go somet...

Hi,
Did you try CVS or SVN? I don't know whether CVS works. SVN definitely does. The repository address is svn://firmos.at/zeos/trunk
You should be able to checkout anonymously.
I use tortoiseSVN and that works well.

Mark

Of course Ben.
Copied my fixed code after I'd found the problem. And forgot to remove the semicolon in the question. Edited the question.
BTW. If everybody says change I will give it a try myself and send the patch.

Sorry.
Mark

Did you try ZEOSDBO SVN version? Please check some recent thread concerning CVS for details. I know there's been some bug with DBLookupCombo's.
I Also think SQLite3 is available, but I never checked that... Wait... YES, there's already some coding there.

Bonne chance!!

Mark

Hi, I have a little design question. If I feed a query without end delimiter to a TZSQLprocessor it does not execute this query. That's because when he parses the string the StementCount is 0. So this code does nothing : Updater.Clear; Updater.Script.Append('Update Cfg set id=1 where id = 1'); Updat...

Hi mparak.
Is it just while debugging that you want the debugger to stop when an exception is raised?(~debugger doesn't stop) Or does none of the bad queries show a message?(~CheckMySQLError doesn't catch the error in ZdbcMysqlUtils) Did you try to log all query traffic by using a zsqlmonitor?

Mark

Hi Ben, A far as I can see you're right. Can you fix it? If you can change it in the latest SVN version and you submit a diff to this forum (or to firmos by pm) there's a good chance it wil be introduced in the codebase (unless the change is very big). Concerning the \\\' case, as I don't know what ...

Hi, I have some bad news. I did try to do this load data local infile on mysql 5.1 and it worked without any problems, I didn't have to change the code. Did you try the change? Just in case the default behaviour of the mysql library changed. Also, did you try to use the libmysql from your server dis...

Trysho, Do you have more details? Zippo's problem with the temporary tables is solved by a very recent patch to the code. If you get the svn version or the patch submitted in an other thread that's solved. If your query is something else, just tell us more. Versions of Zeos, delphi, mysql. Create of...

What action did you take? You should do a checkout. Normally no user or password are needed...

Mark

Hi, in ZDbcMysql.pas you should try to add _CLIENT_LOCAL_FILES to _CLIENT_CONNECT_WITH_DB in the following code. if FPlainDriver.RealConnect(FHandle, PChar(HostName), PChar(User), PChar(Password), PChar(Database), Port, nil, _CLIENT_CONNECT_WITH_DB) = nil then Don't shoot me if it doesn't work. I di...