Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Another problem: CONTINUE moves to 1st record.
Message
 
 
To
30/07/2001 18:00:57
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00537487
Message ID:
00537531
Views:
17
You mean
SET ORDER TO Field1B IN TABLE_B
SELECT TABLE_A
SET RELATION TO Number INTO TABLE_B
SCAN FOR Amount<>0
  IF FOUND("TABLE_B")
      REPLACE Field2B WITH TABLE_A.Amount IN Table_B
  ENDIF
ENDSCAN
Is there any reason you are using !EOF("Table_B") instead of FOUND("TABLE_B")?
I think !EOF("Table_B") wouldn't work properly if SET NEAR ON.

>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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform