Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GATHER NAME vs APPEND
Message
De
18/06/2004 09:14:56
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
18/06/2004 05:46:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00914780
Message ID:
00914996
Vues:
15
Hi Fabio

I didn't know about that bug. Thanks!

I think I'd use lookup if there was an index or not. If the index is present, use lookup's 4th parameter. The NOT EMPTY is similar to your "AND NOT EOF()".

Did you
USE DBF('c_Result') AGAIN IN 0 ALIAS _c_Result
to avoid worrying about c_Result record pointer? That's good, but I don't need it for this.
CREATE CURSOR c_Result (PK I,Field1 I)
INSERT INTO c_Result VALUES (1,1)
INSERT INTO c_Result VALUES (2,2)

INDEX ON PK TAG PK

CREATE CURSOR TheTable (PK I,Field1 I)
INSERT INTO TheTable VALUES (1,0)
INSERT INTO TheTable VALUES (2,0)

UPDATE TheTable SET ;
Field1 = c_Result.Field1 ;
WHERE NOT EMPTY(EVALUATE("LOOKUP(c_Result.PK,TheTable.PK,c_Result.PK,'PK')"))

SELECT TheTable 
BROWSE
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform