Re: How to force the changes made to a DBGrid to take effect?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Unicorn (unicorn_at_somewhere.com)
Date: 10/28/04


Date: Thu, 28 Oct 2004 19:21:31 +0930


"Jason" <Jason@discussions.microsoft.com> wrote in message
news:B97ADD4C-FA47-481F-855A-31D2358CFC58@microsoft.com...
> Hi
>
> I am have a numeric field "Sequence" in DBGrid1. If I change the Sequence
of
> a record and close the form that contains DBGrid1, it is updated to the
DB.
> However, when I change the Sequence value and run a command button
procedure
> that uses the Sequence of that record, it shows the old value. The command
> procedure starts with 'Data6.UpdateRecord' which I thought would replace
the
> old Sequence with the newly entered one, but that wasn't the case.
>
> What do I need to do instead of UpdateRecord?

Perthapos you need to refresh your data.......... If closing and opening
the form displays the change, then it is the view that you are working with
that is causing the problem. Try using a data refresh call after the
Update\record.

Matt
>


Quantcast