SQL select row, update, select next row, update, and repeat for all rows..

Hello all!

I am trying to use sql to select a row and then find the minimum and maximum values in the row, do some preprocessing, update the recordset using in visual basic 6.0, and then go ahead select the second row, find the minimum and maximum values again.. and go on, until the last row.

The problem is I am having difficulties using sql select for a ROWS.. I am aware how to do this for COLUMNS.. if I want to extract the first row from a recordset, find the min max values, and then, extract the second row and so on.. how will it be possible? (discouraged to use VBA, since i am limited to VB only).. any ideas? sample code will be very helpful.

Here is an example of my recordset:


This example only lists two rows currently. I want to extract the minimum and maximum values from each row at a time, and then the second row. The reason for extracting minimum and maximum values is because I want to normalize my data in the range from 0 to 1. All help is appreciated.

Logic:
After I find the min and maximum values for each row, I will use the recordset back, read the same row, and update every columns entry with my normalized data value... then proceed to the next row and do the same for every row in my database.

you're doing every row in the table?

then just find the min and max in your application code

Yes I am trying to search row by row.. find the minimum maximum values in a row, then normalize all values in that row based on the minimum and maximum values and then proceed further to the next row.. and so onwards for all rows.

I am not sure how to implement this currently. Any sample code would be very helpful. Also is it possible to execute something like this through an sql query? I am using ADODB recordset and JET 4.0 OLEDB for my connection string in visual basic 6.0.

regards,
JD