>I kind a rusty so this probably won't be difficul for ya'll.
>
>I am using a Local View using 2 tables
>expertise
>ccode
>cdescripcion
>
>expertisebyapplicant
>cid
>cexpertisecode
>ntime
>
>the view joins these 2 tables in order to have the expertise description.
>I present this View in a grid
>the view has set the table optimistic buffering
>has all the fields as updateable, except by description cause is the expertisebyapplicant the one is being updated and there is not a descripction field there.
>
>the problem is the following:
>when i add a record to the view the only thing i have to do to refresh the grid is to grid.setfocus and it displays.
>
>now, when i do a deletion, i just haven't been able to refresh the grid to get rid of the deleted record. it stays there no matter what i do.
>
>I've tried the followings:
>grid.refresh
>grid.setfocus
>flush table force
>
>grid.recordsource=""
>delete
>grid.recorsource="theView"
>
>
>and since is buffered i just can't performe a requery cuase i have to wait until the user says want to save record.
>
>off course after the user saves the record and i perform the requery, everything is fine.
>
>i little help on this will be gladly welcomed
>
>
>Karben Selim Mejia
Never mind. Go Recno() solve the problem.
regards
.......
DO WHILE .T.
ME.Work()
ENDDO