Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scan Misbehavior
Message
De
05/05/2008 11:17:53
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01315117
Message ID:
01315129
Vues:
29
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
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform