Zeoslib Portal

With the help of Mark, I solved the problem with a newer libmysql.dll he sent me.

My libmysql.dll was really old, so maybe it's the source of the error message.

try to update to a newer dll.

Hope it helps.

Thank you again Mark !

same problem for me. I had a working project but now when I try to open it it fails. I did change the zeoslib version and the mysql database server version (4 to 5).

adding idsouscategories seems to work (the params are passed) but the generated updatesql isn't correct for sqlite. The project is on your PM.

Hi, I've seen a few problems in the 0.8.3.2 version. Some have already been mentioned but I write them back again: - when you set a default value for a field, it ads quotes 'DEFAULT VALUE'. when you edit the table again, it ads new quotes ''DEFAULT VALUE''. It ads new quotes every time there is a ne...

I fixed it by putting the table that needs to be changed in the first place on the sqlquery (select). It seems to work (was previously on the second place). Also added the "idsouscategorie" for the udpate. new select: select nomcategorie, souscategories.idsoucategorie, nomsouscategorie, su...

Hi there, sorry if this isn't an error but my fault, as I'm quite new in the Zeos library (I use 6.3.3 stable with Delphi 6 Enterprise French). I have a ZConnection on a SQLite-3 protocol. I've a Zquery with inner and left joins on 3 tables and I've attached a ZUpdateSQL to it. I've generated the SQ...

Hello, I'm facing a very annoying problem when I try to do a "locate" in a TZQuery. I've an access violation on CompareFieldsFromResultSet in the ZDataSetUtils unit. I've version 6.1.5 and this problem seems to have been corrected in the 6.5.x version or later, but since they are still in ...

I've version 6.1.5, Delphi 6 enterprise and Mysql database. In a TZQuery I've this SQL: select id, sum(amount1) as total1, sum(amount2) as total2, sum(amount3) as total3, sum(amount1+amount2+amount3) as total from orders group by id Now I'm trying to apply a filter on a field in this query: ordertyp...

I've Delphi 6 enterprise French + Zeos 6.1.5 I've a TZQuery with this query "select * from mytable". This query returns many fields and I've to calculate the sum of 2 of them. So I create a TAggregate field in my TZQuery and in the expression I set sum(amountcol1) I then activate it. for n...

I juste installed the Zeos 6.1.5 library, put a TZConnection, TZTable, TDBNavigator, TDataSource and a DBGrid. Everything looks good, I can go trough my table records, but no way to modify the datas. How can I do it ? The edit TDbNavigator button is grayed. I've checked everything and it seems all o...