Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find numbers that contain and add to a diff field
Message
From
24/06/1999 09:29:22
Brad Stickley
Parker Pneumatic Div. North America
Wake Forest, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00233452
Message ID:
00233464
Views:
35
>>>>I have a table with part numbers that show a length for the part numbers in another field.
>>>>
>>>>I need to find all of the numbers that contain "2479" and replace the length for these numbers with a value that is 4 more than the current value.
>>>>
>>>>Can anyone help me with a quick code to do this?
>>>>
>>>>Thanks in advance.
>>>>
>>>>Brad.
>>>
>>>Is this field a numeric field or char field?
>>>
>>>Jeff
>>
>>The part number is a character field and the length is numeric.
>
>Simplitic way
>
>select table1
>locate
>scan for at('2479',partnofield)<>0
>     replace lenfield with lenfield+4
>endscan
>
>
>HTH
>Jeff

Thanks Jeff that did it!

I do very little programming and am working on learning more. Stuff like this is very helpful.

Brad.
He is there and He is not Silent.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform