Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scan ..Endscan how to use
Message
 
 
To
09/11/2004 20:16:24
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00959824
Message ID:
00959826
Views:
7
It's easier to do with a query. Something like
SELECT Left(State.Reg_Code,3) AS Reg_Code ;
  FROM State ;
  WHERE Left(State.Reg_Code,3) NOT IN ( ;
    SELECT ccRegion.Reg_Code FROM ccRegion) ;
  INTO CURSOR crsNewCodes
SELECT ccRegion
APPEND FROM ( DBF("crsNewCodes") )
...
>
>How to use Scan .. endscan to replace in the following codes which are
>worked fine ?
>
>
>
>Select State
>Go Top
>Select ccRegion
>Do While !Eof("State")
>
>	Locate For ccRegion.Reg_Code = State.Reg_Code
>	If !Found()
>		Append Blank
>		Replace ccRegion.Reg_Code With Left(State.Reg_Code,3)
>                =TableUpdate(.T., .T., "ccRegion")
>	EndIf
>	Skip 1 In State
>EndDo
>
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform