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
.......
DO WHILE .T.
ME.Work()
ENDDO