My Grid doesn't refresh data
lazarus / 16-Databases

----------------------------------------------------------------------
AEslabon4 · 2013-06-27 15:27

Hello again! 

I include a simple program to show a problem I'm dealing with: 

I have 3 buttons in my Form:

1-Open a Query and show the result in a Grid.
2-Close the Query
3-Terminate the Program

It works well... But if I made a change on the database using Flame
Robin, the Grid in my Program doesn't show the new data. Only when I
close the Program an run it again the changes are show in the Grid.

Why the Query is not refreshing the data? 
I'm doing something wrong? 

I appreciate the help.

----------------------------------------------------------------------
AEslabon4 · 2013-06-27 23:40

By searching in others Posts. I found the solution to this:  

My Query doesn't refresh because the transaction (TSQLTransaction) is
still active even when I close the Query!! 

Then, the solution is to put the code: 

Code: [Select]  SQLTrans1.EndTransaction;

Immediately after I close the Query. 

Thanks for the Help!!