Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Appending fields from a table
Message
De
20/06/2002 08:06:40
 
 
À
20/06/2002 01:37:10
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00670283
Message ID:
00670539
Vues:
28
Do you have set a relation between the cursors?
Try adding GO TOP before the LOCATE in question.

>Hi Zaltan:
>
>For some reason the SCAN works for the first row of the table and makes the changes. After that, in the Locate for line, the value of RefDocsWithAddres = 0, and nothing gets changed after that in the RefDocsWithAddress table.
>
>>
>>LOCAL loRefDocsAddy
>>SET EXACT ON
>>
>>IF !USED('RefDocsAddy') THEN
>>  USE RefDocsAddy IN 0
>>ENDIF
>>
>>IF !USED('RefDocsWithAddress') THEN
>>  USE RefDocsWithAddress IN 0
>>ENDIF
>>
>>SELECT RefDocsAddy
>>SCAN
>>  SCATTER NAME loRefDocsAddy MEMO
>>  SELECT RefDocsWithAddress
>>  Locate For RefDocsWithAddress.Number = loRefDocsAddy.Number
>>  IF Found() THEN
>>    Replace Speciality WITH loRefDocsAddy.Speciality, Location WITH loRefDocsAddy.City
>>  ENDIF
>>  SELECT RefDocsAddy
>>ENDSCAN
>>
HTH
Zlatin Zlatev,
MCSD (VS6)

Make solutions, not programs!

Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform