Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Refresh Table After Delete
Message
 
À
06/12/1997 12:06:26
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00063847
Message ID:
00064276
Vues:
41
>There are two:
>skip 0
>and
>go recno()
>Fox behaves as if the record pointer has moved; it also works for
>reestablishing the relations, in case you SEEKed a different value in related
>tables.

I've tried these, but SKIP 0 doesn't work (any more?), and go recno() doesn't work in the context, since the deleted record still is available, and we're not sure what recno() to go to. What I've finally done is:
delete
if eof() && sometimes delete last record moves pointer to eof
  go bottom
endif
skip 1 && these skips move pointer
skip -1 && to correct place
This gives a full table refresh, and sets the pointer at the correct record, at least in my tests thus far...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform