I am slugging my way through my first conversion from Delphi 5 TTables to MySQL. Moving records across is something like a little kid eating a big bowl of chili, I can move two records at a time before the MySQLTable quits responding to any methods. Then, when running the executable externally to the IDE I can 'force' two records at time between error messages of "Dataset is not in Edit or Insert mode".
To make the story dicier I finally 'forced' the total 208 records into the new SQLTable. Then I copied the data files off to a SAVE directory. These were the ECase.MYD, ECase.MYI and ECase.Frm. Then I 'dropped' the ECase file and recreated it with the SQL schema. I forced 29 records into it and then gave up and copied the three files with 208 records in them (shown above) OVER the one's I had just created. Well guess what, there were only 29 records in the database.
Does one have to excercise potions or magic spells to get MySQL to act rationally? Thank you for reading. I will be fascinated to hear feedback.
Bizarre MySQL behavior?
We havent faced similar problem. Please send us (evgeniyD*crlab*com) a complete small sample to demonstrate it, including script to create server objects.
Also supply us following information
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client. You can see it in Info sheet of TMyConnection Editor
If you need to insert into table a lot of records you should use TMyLoader component. Please read MyDAC help for detailed information about TMyLoader.
Also supply us following information
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client. You can see it in Info sheet of TMyConnection Editor
If you need to insert into table a lot of records you should use TMyLoader component. Please read MyDAC help for detailed information about TMyLoader.