Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Compute many operations
Message
De
09/09/2004 19:10:11
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00939290
Message ID:
00940883
Vues:
23
hi
i'll try as under
i get message variable"rn" is not found
 select table2 && Note, that we need to open table2 only once, not in the scan 
     append from dbf("crsRand")
       select crsRand
scan
   goto rn in Table1 && move record pointer to rn record in table1
   delete in Table1
endscan

    *delete from table1 where recno() in (select rn from crsRand)
    *use in crsRand && we do not need our crsRand anymore
thanks
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform