Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scan Misbehavior
Message
From
05/05/2008 11:17:53
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01315117
Message ID:
01315129
Views:
28
That's exactly what happened. Thanks.

>It would happen if index on the cursor is set to bondky. The REPLACE will effectively change position of the record in the index causing behavior you describe. SET INDEX TO will fix it. Also it can be done with UPDATE command
>
>UPDATE curRedemptions ;
>		SET bondky = bond.ky ;
>	FROM curRedemptions JOIN bond ON bond.proj = curRedemptions.Project 	
>
>
>>The following code is simple and straighforward, but when I do the replace statement, the last record in cursor is updated instead of the first, and the scan terminates. I've never seen this before. Any clues?
>
>>Scan
>>	lcProject = Alltrim(Project)
>>	If Seek(lcProject, "bond", "proj")
>>		liBond = bond.ky
>>		Replace bondky With liBond In curRedemptions
>>	Endif
>>Endscan
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform