Hopefully this will be an easy question for a Delphi expert out there.
I have an application that is accessing 2 databases via a TQuery using a join and displaying the results in a DBGrid.
The data is being picked up over a 10Mb network connection and, when the query is set to active, there is quite a long delay before the grid displays the results.
We can live with that when the application is opened for the first time.
But I have a problem in that I then add a record to the query results using another TQuery and the INSERT command. The problem is that this action isn't reflected in the DBGrid. The only way to get the new data into the grid appears to be to deactivate and reactivate the query with the join. But, of course, we then get the delay again.
What I'm really looking for is just to open the query at the start of the application and it stays live and active until we close the application.
I confess to not being an SQL expert and so may have completely misunderstood the concept here. But I felt it was the only way to join together the 2 data tables.
But the speed is causing me a problem....