Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET DELETED ON???
Message
From
12/05/1999 13:43:42
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00217935
Message ID:
00217938
Views:
25
Why the LOOP?

>
>I loop through a table multiple times and mark records for deletion that meet certain conditions. How come, even though I have SET DELETED ON, the deleted records keep appearing in the continuous loop/scan.
>
>I have the following code:
>
>DO WHILE .T.
> SELECT mytable
> SCAN ...
> IF ...
> DELETE && Mark record for deletion
> ENDIF
> LOOP
> ENDSCAN
>ENDDO
>
>In the Init of the form I specify SET DELETED ON. When I browse the mytable it shows no records unless I specify SET DELETED OFF and rebrowse mytable.
>
>Any ideas? I must be forgetting something. Thanks for helping.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform