>Now I've got grid questions (which is worse, grids or combos? > >I have a grid displaying columns from several related tables. After the Valid fires in one column, I'd like to update a field that's a checkbox in another column. However, when I issue a > > REPLACE IN MyTable1 MyCheckBox WITH .T. > >I get an error stating that: > > "Record is in use by another" > >All tables are opened shared, buffering is pessimistic row buffering. The only thing I can think of is that the grid wants total control and doesn't like me messing with things <g> ... any ideas why this is happening and how to get around it? > Hi Bonnie,
Try selecting myTable1 then replacing. This is a pain, but the "IN myTable1" expression does not always seem to work.
More to the point, however, why don't you just change the value of the checkbox in the grid? This will force a replace in myTable1 without your having to do anything about it.
Lastly, be sure to refresh() the grid so the new value of myTable1 appears.
No trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.