Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Another problem: CONTINUE moves to 1st record.
Message
From
30/07/2001 18:00:57
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00537487
Message ID:
00537517
Views:
20
Sergey-

>I don't know why it's happend but there is a simplier code that does the same
>
>SELECT TABLE_A
>SCAN FOR Amount<>0
>      STORE Number TO xNbr
>      SELECT TABLE_B
>      LOCATE FOR Field1B=xNbr
>      * To be safe you should check here if the record is found or not
>      REPLACE Field2B WITH TABLE_A.Amount
>ENDSCAN
>
Instead of selecting, why not just:
IF !EOF("Table_B")
REPLACE Field2B WITH TABLE_A.Amount IN Table_B
ENDIF
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform