Zeoslib Portal

I think it's a firewall/DNS/network problem. Do you have a dirct connection to the web without firewall in between? I justchecked to be sure the SVN is working. It does. I suppose CVS will work as well. Are some of your network ports blocked??

Mark

Hi, I don't know why CVS doesn't work, but the sourceforge CVS isn't updated for a while. Since a few months the ZEOS dev team has switched the version control to their own SVN server. (SVN, Subversion, is a newer version control system than CVS) You can access it using a SVN cient, for instance Tor...

Hi MParak, I don't see where SSH comes into play. Maybe because I don't know much about ssh, sorry. So see this answer just as some hints to think about. Let me know if I'm totally wrong. If your client program using ZEOS is executed on the same machine as the database (using ssh), i don't think the...

Hi, Did you try the WhereMode=wmWhereKeyOnly setting on your query component? Normally that would do the trick, unless zeos can't decide which key to use. (Hope I don't have to figure out why that's the case) Give it a try. If that's not the solution we will need some more details!! Database server,...

Firmos, It's not a real patch!! It's a dirty way to shortcut code. What I essentially do is telling ZEOS 'if you can't find a table, well... believe it's there, honestly'. So, if you wan't to integrate it in the source tree, I would advise to add some configuration parameter like 'USE_MYSQL_TEMP_TAB...

Zippo, Probably I have a (more or less dirty) patch for your problem. I have taken the source from the SVN directory and added 1 line to ZDbcMySqlMetadata.pas. I'll try to attach the diff file and the full version.(I don't know what version you are using) I hope it works for you. It did in my exampl...

Oops,

We 've been writing together.

Did you run this code 'dry'? I mean, without the code between the begin and end clauses? Just to make sure it's only the zeos component that is slow. I don't know what these 'Load...' functions do, but they can also be slow. If the loop keeps taking that long we'll have to take a deeper look at it. ...

Hi, In my opinion this should not bedone using ZEOS components. The tools provided by Mysql just are the best for this kind of operations. It seems very unlikely that commandline supportwill completely disappear from Windows or any other OperatingSystem. And when it disappears there will be somebody...

After executing the query using a ZQuery component (method ExecSql) you get the number of updated, inserted or deleted records in the 'RowsAffected' property.

Mark

No that's not true. But the data beiing saved at the very moment the server crashes is lost indeed. However, all data that has been committed should be safe. Also, there's a difference between the different table types you can choose from in MySQL. If you go for Innodb tables, those should be solid ...

Also, shutting down a server is not a good idea while clients are connected...

As far as I know there are none, Sandeep. And I hope there will not be to much other forums until Zeos is really big. That would only spread the little information available by now. It would be nice if every developer using Zeos would read through this forum and send the little patches they made. I'...

Hi Alf, Just add quotes to your statement!! If you print the string you are creating ( Showmessage(ZQuery1.Sql.text); ) You will see the strings are not quoted. Try to build the exact text -including quotes and brackets- you passed to SQLYog before calling ExecSQL. If that doesn't work right away us...

Well, in my opinion it would NOT be good practice. Mysql would not keep working this way if it were. I don't remember exactly how they think about this issue. I'm sure it's in the manual. There you can also find a way to flush your tables automaticly if you really have to. If you need to do the myis...