Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending fields from a table
Message
From
20/06/2002 08:06:40
 
 
To
20/06/2002 01:37:10
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00670283
Message ID:
00670539
Views:
29
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!

Previous
Reply
Map
View

Click here to load this message in the networking platform