Trouble with SQLUpdate

[andi_d]

Hi!

I'm using TMyQuery to work with database.

Now i want to update database entries using the SQLPUpdate Method.

Code i use:

With MYQuery Do
Begin
Try
SQLUpdate.Add('UPDATE Table SET Name = 'Test'
WHERE Nr =1');

ApplyUdates
except
RestoreUpdates;
Raise;
end;

CommitUpdates;
End;.......................................

I'm just a beginner.... What is wrong??? Or is there a better way??

Thank's a lot!!!!!!!

[Ikar]

The easiest way is to execute the query

Code: Select all

MyQuery.SQL.Text := 'SELECT * FROM ...';
MyQuery.Open;
MyQuery.Edit;
MyQuery.Fields[].As... := ...
MyQuery.Post;

> I'm just a beginner...

Ok, SQLUpdate and ApplyUpdates unlikely will be necessary for you at the nearest time.
[/code]

[andi_d]

Thank's a lot!!!

That sounds much more easier!!!

[andi_d]

How can i write the edited value back into the database??

it looks like the edited value hase ony changes lokal!!

when i do a new query to the database the old value comes again!


thank's again!!

[Ikar]

Most probably, you enabled CachedUpdates := True. Set CachedUpdates := False and data will be passed to the server by Post.