Search found 3 matches

by Derek
05.07.2007, 07:15
Forum: 5.x Versions
Topic: Using the tzmysqlquery for updates?
Replies: 5
Views: 4523

Well, I have connected the TzMySQLQuery to a TZUpdateSQL. Is there further code that I have to write; or how do I check the "Update SQL property" to see of the code is correct? Is there a major bug in the components; surely this is a fairly standard type of operation? This query is connect...
by Derek
04.07.2007, 14:43
Forum: 5.x Versions
Topic: Using the tzmysqlquery for updates?
Replies: 5
Views: 4523

Unfortunately not - the code seems to accept the Post but still crashes on the ApplyUpdates - and if you leave the ApplyUpdates off, then the record is not updated. Well, upgrading to version X is always good :mrgreen: Anyway, I think your problem can be solved adding a .Post before ApplyUpdates, li...
by Derek
04.07.2007, 12:57
Forum: 5.x Versions
Topic: Using the tzmysqlquery for updates?
Replies: 5
Views: 4523

Using the tzmysqlquery for updates?

Running Delphi 5..... when I try and use the tzmysqlquery to do an update: [font=Courier New] with qryUpdate do begin Active:=false; SQL.Clear; SQL.Add(myQueryString); Active:=true; First; Edit; FieldByName('Name').AsString := 'TEST!'; ApplyUpdates; end;[/font] the program crashes on the ApplyUpdate...