I need to update a table based on values in another table. In addition, I need to increment a value each time (the value that is updated in the second table.
To accomplish this, I selected my records from my table into a new table.
Then, I was going to use a WHILE NOT EOF statement to go through this temporary table, and update the records in the original table. However, I am having trouble scanning through this table using the while. I can't get the syntax to work. Can you give me ideas on how to do this, or the syntax to make it work?
Thank you.l