Information générale
Catégorie:
Codage, syntaxe et commandes
>>>>>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.
even more simplistic
select table1
replace lenfield with lenfield+4 all for like( '*2479*, partnofield)
Paul
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement