Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refresh Table After Delete
Message
 
To
06/12/1997 12:06:26
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00063847
Message ID:
00064276
Views:
36
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform