Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jamie Osborn
  Where is Jamie Osborn?
 Melbourne
 Australia
 Jamie Osborn
 To: Richard Jones
  Where is Richard Jones?
 Truth or Consequences
 New Mexico - United States
 Richard Jones
 Tags
Subject: RE: grid update
Thread ID: 33796 Message ID: 33819 # Views: 1 # Ratings: 0
Version: Visual FoxPro 5 Category: Grids
Date: Thursday, December 04, 2003 12:41:46 AM         
   


> Jamie,
>
> Thanks for responding!
>
> To clarify a bit more .... Are you saying that you have a parent/child form with the child records in a grid on the form ?
> YES
>
> Are you editing parent records/child records/both in the browse ?
> NO/YES :)
>
> I WANT TO EDIT (CHANGE QUANTITY ETC) THE CHILD IN A BROWSE. THE DATA ENVIRONMENT CONTAINS ALL TABLES IN THE CHILD/PARENT ENVIRONMENT.
>
> THERE IS A RELATION SET BETWEEN THE PARENT/CHILD SO THE GRID WILL SHOW THE COROSPONDING RECORDS TO THE KEY IN THE PARENT DB. WHEN I CHANGE ANY FIELD VALUE IN THE PARENT OR CHILD AND DO A THISFORM.REFRESH CALL, BOTH PARENT AND CHILD ARE TOTALLY BLANK!
>
> WHAT AM I MISSING?
>
>
> > > Dudes! (and Dudettes :)
> > >
> > > I have a form with a grid. I update the grid with a routine inside a button on the form by a browse with controls call (I know, cumbersom...bear with me). When I close the browse after editing certain fields, I take some of the data and update the parent db with replaces. I then do a THIS.FORM REFRESH. The Parent form updates correctly but the grid does not! Version is both 5.0 and 6.0. Any ideas? I am updating a legacy accounting system from version 1.02 that I wrote in 1991.
> > >
> > > Thanks in advance!
> > > Richard Jones
> >
> > To clarify a bit more .... Are you saying that you have a parent/child form with the child records in a grid on the form ? Are you editing parent records/child records/both in the browse ?
> >
> > Cheers,
> > Jamie
> > jamie.osborn@foxite.com
>
>
> Richard Jones

Are you moving the record pointer in the parent table at all ? You can check this by storing it and comparing it after. eg.
lnRecNo = RECNO("myparentalias")
BROWSE && etc. etc.
REPLACE && etc. etc.
thisform.Refresh()
WAIT "RecNo was : " + TRANSFORM(lnRecNo) + " Now it is : " + TRANSFORM(RECNO("myparentalias")) WINDOW


The point of me asking is that it looks like you are breaking the relation or moving off to EOF() in the parent.

Cheers,
Jamie
jamie.osborn@foxite.com

ENTIRE THREAD

grid update Posted by Richard Jones @ 12/3/2003 7:18:00 PM
RE: grid update Posted by Jamie Osborn @ 12/3/2003 11:40:01 PM
RE: grid update Posted by Richard Jones @ 12/4/2003 12:26:48 AM
RE: grid update Posted by Jamie Osborn @ 12/4/2003 12:41:46 AM