Adding records to TSQLQuery

[LemonParty]

Hi. I am using TSQLQuery with TDBGrid. When I open Query – everything OK, old records are visible. I am doing the next thing:

Code: Pascal  [Select][+][-]

1. begin
2.   Query.Append;
3.   {edit fields here}
4.   Query.Post;
5. end;
6.  

The code above seems work fine (new records appear in DBGrid). But when I close and open the dataset records added this way disappear. How to make them left?

[TRon]

See wiki about transactions.

[LemonParty]

Code: Pascal  [Select][+][-]

1. Query.ApplyUpdates;

Do the thing. Thank you.

[TRon]

Thank you for reporting back LemonParty.

Note that I specially mentioned the link in the wiki to get yourself acquainted with transactions as the wiki article explains what a transaction actually does.

Now, that might or might not be applicable to your situation f.e. because you are working with a local database but it definitely comes into play when working with a remote database. You can setup your code so that there is no need to (manually) perform transactions but that is usually an undesirable situation for remote servers.