I'm using vb6 and connecting thru ADO.
I want to know if its possible to select
an item from the db, then go thru each item
in the recordset and if any equal 0 then change it to 1
Basically I have a quantity field and if
that value is zero I want to change it to
1 only temporarily.
I'll be using the code in a Crystal Viewer form
and I do not want to update the db.