Update Sql Help
Posted on 2002-03-13
I have a listview that displays invoice information (Invoice Number, Date, Payment Status, Amount). When it comes time to post payment to each invoice, a check box should be checked indicating that payment should be posted to this invoice.
Question is, what is the most efficient way to run the update statement to reflect payment on the items that are checked?
Im using vb6 and sql 7
Here is the layout of my table:
ExamNumber <---This is Invoice Number
Status <--- Integer value with the following values 0 = unpaid, 1 = paid, 2 = logical delete.
So if the listview displayed the following information:
ExamNumber Date Total
62000 3/10/02 75.00
62001 3/10/02 75.00
62002 3/10/02 75.00
And all three values were checked, whats the best way to update the table so the status on each exam number is updated to 1?