Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Number of undeleted records in a table
Message
 
À
28/09/2004 06:59:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00946531
Message ID:
00946653
Vues:
20
>hi,
>
>i want to count deleted records,at my code
>
>thanks.
local lcWasDel, lnDeletedRecords
local array laJunk[1]

lcWasDel = set("DELETED")
set deleted OFF

select ;
 count(*) from <Alias> ;
  where DELETED() ; 
   into array laJunk

set deleted &lcWasDel

lnDeletedRecords = iif(_tally > 0, laJunk[1], 0)
 ? There are "+ trans(lnDeletedRecords) +" Records"
Regards from Berlin

Frank

Dietrich Datentechnik (Berlin)
Softwarekombinat Teltow (Teltow)

Frank.Dietrich@dd-tech.de
DFPUG # 327
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform