Sorry, I still don't get it. Say you have a table with 6 rows, column 1 is named A and column 2 is named B. Then you do a select * from that table. I would view that asrow A B=============1 x y2 a b3 e f4 n m5 t o6 q dSo that the value of row 4 column a was 'n' and the value of row 2 column b was 'b'How do you extract those values from the stem?
This:do i = 1 to rs.0say rs.i.nameendIs actually more of the construct I first pictured. But, my first implementation didn't work correctly and I gave up on that, thinking for some reason that it wasn't possible.This discussion got me thinking about it again.This change would mean any one already using the existing format would need to change their code.I would like to hear what people think?