Zeoslib Portal

Dear Friends, I have worked with Delphi and Zeos for a while now, and recently made the move to get started with Lazarus and Zeos. After downloading the latest of both I went through a smooth and uneventful installation. When playing with my test project I find that when I try to connect to a databa...

I agree with you in that we did not read the MySQL documents well enough, and are paying the price. follow the link I provided though and you will see that the case is far from Cut and dried as you imply. http://www.bitboost.com/people/free-software-open-source-licensing/mysql-license/ Regards M

Dear Friends, We were recently contacted by MySQL (Yes they emailed, then phoned us in South Africa - All the way from the UK) A really rude wake up call. They tracked me down using the MySQL forum membership. Is nothing sacred? It seems that the worlds most popular OPen Source Free Database is not ...

Dear Friends, I often need to display a MySQL calculated field in a DbGrid and find that if I use the Format(calculated_field, decimal_places) thingy I get the results as a string and often the thousand separator of comma causes the thousands to be lost. I solve this by implicitly setting the displa...

Dear Mark, I too found the same bad news on the MySQL forums, just this minute. Thanks anyway. The option of iterating through the records is not available as the data I am moving is huge. MySQLDump works fine, but hangs the server if dumping large tables that are being edited, as it places a lock o...

Dear Friends I am using MySQL and am able to issue the following: select * from `setup_new` into outfile "c:\_setup.txt" The server is remote and the text file is on the server (somewhere). How do I type the path so that the resulting file is on my PC, not on the remote server? If I use my...

Dear Friends. I recently found that when doing a tZTable.Edit if the table had no unique fields the wrong records were updated. If appears that the table.edit, is meant to edit the current record issues the SQL updat table where fields = values command and therein lies th eproblem. If the table has ...

I have been able to do a multi table update, in MySQL, but the syntax is clearly different for Firebird.
Therein lies the problem.

Dear Friends I am trying to update a value in one table with a value form a different table. The update command seems to be the logical way. Can somebody help me with the SQL command that would update a single field from one table to another. Update Table1, Table2 set table1.EndValue=Table2.somefiel...

I obviously read him wrong.
My Bad

Hi folks, I was reading up on Michael Seeger's (ZeosLib QA- and Documentation Team) explaination on the use of TZtable component and I quote:... -------------------------------------------------------------------------------- TZTable TZTable acts like BDE's TTable. As a principle you only should use...

Dear Friends, It seems from what I read on this and other Forums that Zeos can be made to install and work on Lazarus. What is clear is that one needs to do all sorts of magical stuff and say the secret word before it all "happens". Does any kind soul have a record of the installation proc...

Dear Friends,

I subsequently downloaded ZeosLibDBO.chm and found that many of my questions have already been answered here.

many thanks

Mo
www.cad.co.za

Dear Friends I have used the basic Zeos components (TZConnection, TzQuery, TzTable etc..) but have recently needed to raise my game to the next level. The (ZSQLProcessor, ZSQLMonitor, ZUpdateSQL, ZStoredProcedure) components clearly came to mind and it was apparent that there does not exist any defi...

Hi mdeams, In answer to your question, I need help at run time, not in debug mode. I get the impression from your reply that the ZsqlMonitor is the answer, but have no clue how this component works. I will scratch around and see if I can figure out how to use this. Will let you know in this thread h...