Page 1 of 1

Problem with updating and inserting MYSQL records

Posted: 15.12.2006, 16:20
by Sunset_Solutions
I have developed an application in delphi 7 using ZEOSLIB 6.6 but on the developing pc everything works fine but when I run the program on an other pc and update or insert and records everything seems to work fine because they are updated in the grids but the changes are not realy written into the database. so when I restart the program I notice that the database remains intact without the changes.

Can somebody tell me what I'm doing wrong??

Posted: 15.12.2006, 23:40
by kmr
Could you be a little more precise?

Are you running the same version of MySQL on both machines? Which version(s)?

How do you insert/update records? ZQuery.Edit, Zquery.Post or manual with sql statemants (Update x set y=z where a) ?

Commiting data

Posted: 18.12.2006, 05:18
by alpayd
Call ApplyUpdates methos after post method.if ZConnection autocommit properties are true.
this is can be solve your problem.

Posted: 19.12.2006, 07:46
by bangfauzan
Set CachedUpdates to False, if not, make sure to call ApplyUpdates method after Post.