MySql Insert and Post Error

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Zsolt Csillag
Posts: 30
Joined: Sun 28 May 2006 16:09

MySql Insert and Post Error

Post by Zsolt Csillag » Sun 28 May 2006 16:20

Hello,

I use Delphi 2005 and MyDac 430d9.

Today this happened to me twice (the second still persists):

If I make a new record to _any_ query or modify any field, the
program accepts without any error.

However when I quit the program and start it again the modifications
are not there.
The same is true if I start the program from the .exe file, not from Delphi Ide.

When the first error happened it resolved itself after several rebuilding
but not now.

Another thing: the exe file I made yesterday works very well, so it seems
that this 'bug' is written in the exe file.

It is very important to me to finish this program - if the problem still persists I cannot continue the software.

Thank you in advance

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Mon 29 May 2006 09:47

Please check value of CashedUpdates property of the MyQuery (or MyTable) you use to update records. If it's True, try setting it to False and test the application again. If the problem persists, please send us (EvgeniyD*crlab*com) a complete small sample to demonstrate it, including script to create and fill table.
Also supply us following information
- Exact version of Delphi
- 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

Post Reply