Zeoslib Portal

I'm creating an application with delphi 2006 with zeos 6.6 beta on my sql 5. At first all worked perfectly, but since I imported a lot of records in few tables I can't insert new records and, where I can, when I try to post new records nothing happens. Infact closing and reopening application no record is saved. Any idea? This is the first time I usa both zeos and my-sql so... I'm quite in difficulty!

thanks a lot

Rugoetto

Hi Rugoetto,

Can I summarize your problem as follows?
- You had an existing program using D2006, mysql5 and zeoslib 6.6.
- This program worked. Inserts and updates worked as expected, even after restarting the application.
- You loaded extra data in the tables using an external tool (eg mysqlimport)
- No other changes (table structure, mysql storage engine, indexes,...) happened.
- Now the program does not accept inserts or updates anymore.
- You don't get error messages

Sounds strange, but we see all kind of weird things here.

Mark

Do you have AutoCommit in your TZConnection set to false or maybe CachedUpdates on one of you datasets set to true?

Regards,

Ben

Things are exactly as you described. Since I inserted about 8k records using TUti, a software based on BDE, to import a previous Paradox DB all worked fine. But the thing makes me crazy it's no error or exception during post. In this first phase I set autocommit to true, to be faster. After I would insert cashed updates in code.

thx