En Masse changes vs. individual updates

[carlee]

Hi there,

I have a button that when clicked, executes 7 seperate
queries. THis is done to complete a record archiving
process.

Problem:

The queries work fantastic, but for one archive at a
time. I want to be able to click the button once and all
items to be archived will be.

How can i get this to work?

Regards,
Carlee

 

[John Vinson]

The queries work fantastic, but for one archive at a
time. I want to be able to click the button once and all
items to be archived will be.

How can i get this to work?

By running a query that updates all the items. Without knowing what
code you now have nor anything about your table structures it's a bit
hard to say just how this would be done, but I'd guess that you would
have the code execute one or more queries, each of which would update
zero or more records based on some criteria.