Now I understand what you want, but it looks like something strange. Why dont just execute many statements and accumulate them in some container and after that fetch results of this statements ? For me It looks like something foreign in HDBI especially because I did not see any support of such things in native database interfaces not in Postgresql nor in SQlite.

2013/10/16 Gauthier Segay <gauthier.segay@gmail.com>

no the use case is to issue a bunch of disparate select statements,
i.e. retrieving data from several tables in a single roundtrip.

select 1,2,3

select 'a', 'b'

In this case, I'd like to call the API in this manner (or something better):

-- statement is prepared
rows1 <- fetchAllRows statement
_ <- nextResults statement
rows2 <- fetchAllRows statement
-- continue

right now, with hdbc-odbc (nextResults doesn't exist though so I don't
call it) rows2 will be an empty list, I'd expect it to be[(SqlText
"a"), (SqlText "b")]

I assume in the case of odbc, the related C function is SQLMoreResults

http://msdn.microsoft.com/en-us/library/ms714673%28v=vs.85%29.aspx