Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is this possible?
Message
 
 
À
30/08/1999 12:27:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00259224
Message ID:
00259265
Vues:
22
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform