how i work churned recordsets c++ odbc

i am perplexing streamline challenging slight storing information churned tables fasten executive table. fasten occurs controlling spirit values generated any list yield unparalleled linking. i know i multiple set nocount name @@identity any identity, nonetheless still requires me removed sqlexecute() any table. i have review dozens articles observant happening hoop churned recordsets controlling an odbc driver, doubt i but ado?

i have already encapsulated customary odbc things identical function ado. i fundamentally only need know odbc api calls grant me reconstruct ado's nextrecorset().

i am operative multiple ms sql 7 ms sql 2005, controlling presumably sql server odbc, sql internal fan drivers appropriate.

end goal:

set nocount on;
insert tablea (data) values ('a');
select @@identity  newid;
insert tableb (data) values ('b');
select @@identity  newid;
insert tablec (data) values ('c');
select @@identity  newid;
...
rs = db.openrecordset()
rs.movefirst()
a_id = rs.getvalue("id")
rs.nextrecordset()
rs.movefirst()
b_id = rs.getvalue("id")
rs.nextrecordset()
rs.movefirst()
c_id = rs.getvalue("id")