Zeoslib Portal

Michal, thanks for the link, but maybe I oversee something, I only found ZTestStoredProcedure.pas which is dealing with stored procedures but that is not what I am looking for; What I need is a simple cooking recipe how to use ZEOS to a) sumbit a stored procedure (function in my case) using ZEOS com...

Michal,

which test directory? I can't find a directory test in the ZEOSDBO-7.1.4-stable.zip ...

Werner

I want to use stored procedures in my project but do not have any idea a) how to submit a function as stored procedure to MySQL DB using ZEOS components b) how to call this function from within my project using ZEOS components. I searched the web but did not find any documentation (some of the links...

I have solved the Issue >>EAccessViolation in module libmysqld.dll<<.

As I stated above I found a post on mysql forums in which the author suggests to put all mysql related stuff inside the thread procedure. I have done this and no Issue furthermore.

Werner

After some investigation I found some interesting facts at this issue: It looks like that this problem is a thread related prob. In my app the part of the prog where the issue happens is a thread importing data into the database. This works fine using libmysql.dll connecting to a MySQL Database Serv...

I think You should use TZQuery.Execute; instead TZQuery.Open; TZQuery.Execute can only be used together with create, insert, .. (SQL queries which modifies table(s), TZQuery.Open is to use together with select, ... In my case I cannot use Execute, I must use Open ... If I use a remote Database (lib...

Hi! Using libmysqld.dll from MySQL 5.1 in my project I get 'accessviolation at address 01991FB9 in module 'libmysqld.dll' writing from address 000000054'. This happens adding record to the database using ZDataSet.TZQuery.Open. Changing the libmysqld to MySQL 4.1 everything works fine as expected. I ...

I try to use a DBGrid Object to display data from a MySQL database with 3 tables containing normalized data. So I created a test app, put TZConnection with connection information to the MySQL database, TZQuery (connection = TZConnection, SQL property = select * from tracks, album, artists where trac...

Hi, I am developing a app with Delphi 2007 using ZEOS 6.6.3 stable and MySQL 5. I use 7 tables to store data, on 6 of them using last_insert_id() to retrieve the auto_increment id of the last inserted row works as expected, but on one table it does not. I receive allways 0 (zero) as result using >se...