Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET DELETED ON???
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00217935
Message ID:
00218047
Views:
21
>DO WHILE .T.
> SELECT mytable
> SCAN ...
> IF ...
> DELETE && Mark record for deletion
> ENDIF
> LOOP
> ENDSCAN
>ENDDO
>

All you need is:
select MyTable
scan
   if ....
      delete next 1   && I always put the optional next 1 scope
   endif
endscan
This, of course, does a full table scan. Use a Scan scope to just scan a set of records.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform