Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Find numbers that contain and add to a diff field
Message
 
À
24/06/1999 09:14:57
Brad Stickley
Parker Pneumatic Div. North America
Wake Forest, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00233452
Message ID:
00233463
Vues:
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

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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform