I Bet you have a ThisForm.Refresh() or equivalent command in the AfterRowColumnChange() event in the grid. This has the effect of resetting the datasource in the grid. Remove this and all should be OK
Dave CRozier
Dave Crozier
The Table is being held in cache memory so running it the second time shows an increase in speed. I guess that you are NOT using an index. This will speed up the Query no end! as Rusbhmore optimisation will be used. Create an index nased on the account Id field and just see!!
Dave Crozier...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.