>Hi Gar,
>
>In my case there is no sql and no view. just a table 'sostrs' in data environment.
>I am looping through another table with a relation set to sostrs. inside the loop i issue a
>replace statement. i think (?) that the first iteration of the loop is okay - but subsequent iterations return the record
>is in use error
>
>in other posts here, on a thread on 'error 109' - some suggested that if there was a grid where the control source
>references the table you are having a problem with, that you should temporarily eliminate the control source reference.
>i tried this, but it didn't work.
>
>i have continued to look at the code, and, oddly, as best as i can tell so far, an earlier version of the code works.
>yet the only differences (i think) between the current version and the old version are
>(some select statements into cursors are made - but not on the table in question) and some text boxes and a
> grid column were added to a form.
>
>i don't see how these changes could cause this problem !


Are you sure that you always have the table selected when you do the replace? A select statement to create a cursor automatically makes the newly created cursor the default work area.

Are you sure that the added column gives the table you are replacing as the controlsource? Grids based on multiple tables have all sorts of problems in VFP -- one reason (among many) to use a view or cursor if you need to base a grid on multiple tables.

If neither of these is the cause, you could cut and pase the EXACT code that is causing the problem -- the setup for the loop and the entire loop.

I'm not sure my guesses are very good, but I need better info to make better guesses.