>Given an optimistic table buffered cursor against an updateable view:
>
>Suppose the cursor has already been queried , and changes made by the user.
>
>There is an existing record in the base table, that was not included in the query and thus is not in the cursor against the view.
>
>Is there a way to add this existing record to the cursor without requerying the view?
>
>My guess is no -- but there are people on this thread who do amazing things.
You could try:
select * from basetable where _filter_criteria_used_in_current_view ;
and Basetable.KeyID not in (select keyid from CurrentView) ;
into cursor crsTemp nofilter
select CurrentView
append from dbf("crsTemp")
Mark McCasland
Midlothian, TX USA