August 29, 2008 06:57pm pdt

Member Login

Hall of Fame

Yearly

1ziolko 326,855
2ciuly 225,985
3TheRealL... 148,008
4MerijnB 144,827
5Geert_Gr... 132,301
6SteveBay 122,088
7developm... 116,878
8rfwoolf 102,158
9ThievingSix 96,336
10Johnjces 81,552
11rllibby 64,270
12dinilud 49,668
13CodedK 46,191
14kretzsch... 41,841
15atul_par... 41,525
16EddieShip... 36,154
17mikelittlew... 36,100
18Steven-F... 31,043
19mokule 29,652
20Workshop... 29,099
21wd123 24,878
22aikimark 23,847
23bernani 19,191
24calinutz 19,008
25RickJ 17,874

	[x] Attachment Details

Delphi, TQuery and keeping a DBGrid refreshed

Zone: Delphi Programming

Tags: delphi, dbgrid, tquery

Hi All,

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....

Many thanks,

Trevor.

Start your free trial to view this solution

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.0

Question Stats

Zone: Programming

Question Asked By: trevorb

Solution Provided By: kretzschmar

Participating Experts: 4

Solution Grade: A

Translate:

Loading Advertisement...

20080723-EE-VQP-34