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:44:29
 
 
To
29/09/2004 01:52:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00946531
Message ID:
00947066
Views:
18
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