Refreshing a query data in a form...

[rasaliad]

Hi uniguier,

 

 

I have the following problem:

 

I have a simple Unigui Web App running in a Contabo VPS, this form has a query selecting data from a table in a Firebird database, this display some text and numeric data in TUniDBText, then I have a delphi vcl application that remote connect to the same database to the VPS and make some changes in the underline table, then after changes are done, I press the refresh button in the unigui app, the onclick event close and open the query, but the data display in the DBText stay unchanged, I wait for a time and then click the refresh button again and the information still display unchanged. I'm afraid if this is because ajax technology, I don't know about ajax and javascript... how can i get the data display correctly when refreshing the query in the unigui app, after the delphi vcl app update it in the background. I hope you understand my problem.

 

 

Thanks in advanced.

 

Using:

Delphi Xe6

Unigui 0.98

FireDac

FireBird

Contabo VPS

 

Rafael Liriano

 

 

[Farshad Mohajeri]

Hello

This issue was answered in forum. It is related to FB's transaction handling. Please search forum and you will find the related thread.

[adragan]

Commit the transaction and after that reopen the query.