Problem with updating and inserting MYSQL records

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
Sunset_Solutions
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 15.12.2006, 16:02

Problem with updating and inserting MYSQL records

Post 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??
kmr
Fresh Boarder
Fresh Boarder
Posts: 17
Joined: 12.06.2006, 22:18
Location: Northern Germany (really northern)

Post 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) ?
alpayd
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 17.12.2006, 05:28

Commiting data

Post by alpayd »

Call ApplyUpdates methos after post method.if ZConnection autocommit properties are true.
this is can be solve your problem.
bangfauzan
Senior Boarder
Senior Boarder
Posts: 50
Joined: 31.08.2006, 10:41
Contact:

Post by bangfauzan »

Set CachedUpdates to False, if not, make sure to call ApplyUpdates method after Post.
Post Reply