Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP new bug: UPDATE with SET RELATION fails
Message
 
 
À
02/12/2001 10:36:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00588420
Message ID:
00588507
Vues:
22
Hi Andrus,

It looks like you want to update only records in the Cursor1 that have related records in the Rcursor
SELECT Cursor1
SET RELA TO Field1 INTO RCursor ADDITIVE
* With the record looks
SCAN FOR FOUND("RCursor") 
    REPLACE Field1 WITH RCursor.Field1 
ENDSCAN
* or With the file lock
REPLACE Field1 WITH RCursor.Field1 ;
    FOR FOUND("RCursor")
>>It looks like a bug. However, it still not a good idea to combine set oriented UPDATE-SQL command with record oriented function EOF(). The result could be unpredictable.
>
>If this is not a good idea, how to implement the functionality of this code
>using only good ideas ?
>Unlike access, vfp doesn't allow to use multiple table names after UPDATE
>clause!
>Is it possible to implement such update without SET RELATION ?
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform