>>>Okay this is a really simple uestion that I just don't know the syntax for. I have a program that needs to read a field, perform a calculation, and update another field in the same table with the results of the calculation. The program cycles through every single record in the table and performs the same calculation. I opened the table with USE, enter the loop, read the value (cvalue = table.field) and perform my calculation. The one thing I don't know is the code that updates the other field in the table from within the loop. WHAT IS THE COMMAND??? Thanks and please don't laugh.
>>
>>
>>you really don't need to cycle....
>>
>>replace field with (field calculations) all
>
>What is (field Calculations)? ie- how do I specify what to do with each field. Note- the calculation is about 30 - 40 lines of code.
>
>Most of my background is in COBOL- hence the sequential record processing tendency...
field calculations can be a udf. multiple fields syntax would be
replace field1 with udf1, field2 with udf2, etc.