Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this possible?
Message
 
 
To
30/08/1999 12:27:47
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00259224
Message ID:
00259265
Views:
20
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform