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
Post Record & Insert new
Moderators: gto, cipto_kh, EgonHugeist
-
mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
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
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
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
thx