Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number of undeleted records in a table
Message
From
29/09/2004 02:55:13
 
 
To
29/09/2004 02:44:29
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00946531
Message ID:
00947068
Views:
19
use it like this

lnDeletedRecords = iif(_tally > 0, laJunk[1], 0)
? "There are "+ trans(lnDeletedRecords) +" Records"&& error messag

>hi ,
>thank you fpr reply.
>this is the code,wher is the erorr,
>
>local lcWasDel, lnDeletedRecords
>local array laJunk[1]
>
>lcWasDel = set("DELETED")
>set deleted OFF
>
>select ;
> count(*) from ttest ;
>  where DELETED() ;
>   into array laJunk
>
>set deleted &lcWasDel
>
>lnDeletedRecords = iif(_tally > 0, laJunk[1], 0)
> ? There are "+ trans(lnDeletedRecords) +" Records"&& error messag
>
>
>thanks
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform