I have SQL standard tools. I want to do a mass substitution for a particular field in an access database. There is this sample program --sql-upd.bas. It does an update to one record. But I want to make the same substitution to many records in the table.
Several possibilities have entered my mind. Since I'm not quite sure how SQL tools works, here are some ideas:
just loop back to the point where the SQL statement is submitted?
Do an SQL fetch and then loop back?
I could experiment and waste a lot of time. Better to ask the question.
Sample code would be appreciated. Thank you.
Several possibilities have entered my mind. Since I'm not quite sure how SQL tools works, here are some ideas:
just loop back to the point where the SQL statement is submitted?
Do an SQL fetch and then loop back?
I could experiment and waste a lot of time. Better to ask the question.
Sample code would be appreciated. Thank you.
Comment