Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems deleting records in a view
Message
 
 
To
21/05/2002 21:26:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00659687
Message ID:
00659689
Views:
25
The DELETED() function accepts only alias or work area number as a parameter not record number. You can check only if the current record is deleted. To check other record you've to move pointer to it.

>Hi
>
>Here is my problem, I'm using a view (no one else is using the tables or DBC, etc).
>Every time I begin to delete records in a determined 'sequence' certain record doesn't get deleted, from my code the record is supposely deleted already. This is what I apply before I want to delete a record:
>
>
> IF !DELETED(RECNO())
>
>
>This is weird 'cuz the record does gets deleted if don't apply the 'sequence' of 'deletes'.
>I think the 'sequence' itself means nothing as I'm testing the code against an 8 records table and the whole idea itself doesn't make any sense at all.
>I also make sure that the pointer is in the right record before I try to delete it, but even so I can't make it work.
>One thing that is important to me is to use a code similar to the one above as this view probably is going to be used for more users, I guess this is good way to check whether the record is already deleted, but in case this is not always effective could you show a better way.
>
>What could be wrong?
>
>Thanks in advance
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform