Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP new bug: UPDATE with SET RELATION fails
Message
 
 
To
02/12/2001 10:36:07
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00588420
Message ID:
00588507
Views:
21
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform