Updating record in TDbGrid with CachedUpdates

I am obviously missing something straightforward. I have a TDbGrid hooked to a TQuery with cachedupdates to a SQl Server 7 table allowed. A navigator Post does not save the change. I have tried a ApplyUpdates and a TDatabase.Commit with no success. Any ideas what I am overlooking?

Thanks, Tom.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

When you use TDatabase, you have to use TQuery.CommitUpdates before of using Tdatabase.Commit.

ApplyUpdates works only when Tdatabase not used.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
boardtcAuthor Commented:
Thank you but I am still confused and still have a problem. The problem first: an implicit post does not save, in other words, if they make a change in the grid and then move to a new record it does not save. How can I get a commit called in this situation.

Also, the help says to do a TDataBase.StartTransaction, followed by a TQuery.ApplyUpdates, a TDataBase.Commit and the TQuery.CommitUpdates. Can I just do the later as you suggested?

Thanks, Tom.
boardtcAuthor Commented:
Well, I got around it, I now do a CommitUpdates in the TQuery.OnAfterPost which works for both an implicit and explicit post. I still am concerned about doing the StartTransaction, Applyupdates and Commit though. I would like to find a good source of information, so I could read up and understand what is going on. Tom.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.