Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find numbers that contain and add to a diff field
Message
 
To
24/06/1999 09:14:57
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:
00233463
Views:
33
>>>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

It's Time to get a gun.

That's what I've been thinkin.

I think I can afford one, If I do a little less Drinkin.

www.TrueGeeks.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform