How to update a read only dataset

Posted by Paul Doucette on January 12, 2000 at 17:54:10:

Happy New Year Guido,

I would appreciate your help with a problem, if possible. I'm tring to create a procedure that does the following:

Executes an inner join using a query;
Initialize an integer variable to 1;
Loops through the returned dataset;
Assign the variable to a field in the record;
Increment the variable for the next record.

I have the dataset from the inner join but I am having difficulty working with the read only dataset. How do I walk through the dataset and update the field?

Any assistnace you could provide would be greatly appreciated.

Paul