Zeoslib Portal

never done that but in theory, you should write lock table, execute insert, execute last_insert_id and then write unlock table...

that's only theory...


look at http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html for more details...

take a look at version property of ZConnection... and for query try: Qry.Sql.Text := 'INSERT INTO names (ID, FIRST, LAST) Values (:ID, :FIRST, :LAST)'; Qry.ParameterByName('ID').AsInteger := 9; Qry.ParameterByName('FIRST').AsString := 'X'; Qry.ParameterByName('LAST').AsString := 'Y'; Qry.ExecSQL; Al...

code looks good to me..
on what line exactly you get access violation?

Looks like you have one more field in table that is set to not null and you are not filling it with data.

Can you post SQL table structure?

it works. thanks.

I'm using Delphi 2009 and ZeosLib 6.6.6 stable on Windows 7. On designtime when i set ZConnection.Connected to True i get error "can't find libmysql41.dll libmysql.dll"... On runtime everything works fine. I copied files to both windows\system32 and application exe folder. Any ideas? Thnx ...

i had same error when i tried to make access frontend some time ago...

check if your database field names are correct in your code. i made that mistake...

Try to put code in OnChange event instead of OnSelect... That will work i think?

I think You should use TZQuery.Execute; instead TZQuery.Open;

sorry for mistake, it's Rad Studio 2007, not 2009.
I upgraded Zeos to 6.6.5 and XP sp3 and still have same problem.
What kind of driver is used to connect to SQL server?

Hi, I'm using Delphi2009 ent and ZeosLIB 6.6.2 on developer machine under WinXP SP2 and MSSQL 2008 on Windows server 2008 standard on server machine. When i try to connect from delphi to SQL i get error: The USE database statement failed because the database collation %.*ls is not recognized by olde...

Hi everyone, I'm using MS SQL 2000, Zeos 6.6.0 and Delphi 7 SP1. When I try to execute SELECT query error "List index out of bounds ##" where ## is number of fields in table.

I tried same with older (6.5.0) version, and with it app crashed with access violation.

Can somebody help me?

Thanks for response... will try with a newer one and will wait for beta...

i'm using zeoslib for mysql acces for almost 4 years now and it's great stuff...
thanks...

version is "ZeosLib 6.5.1-alpha CVS-Version as of 13-10-2005" (copied from version file from root dir)... there is no ZComponentDesign file in any folder, and i tried with ZeosDBO.bpg but still nothing...