[Haskell-cafe] Announce: HDBI-1.3 and friends

Alexey Uimanov s9gf4ult at gmail.com
Wed Oct 16 15:50:33 UTC 2013

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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.haskell.org/pipermail/haskell-cafe/attachments/20131016/2c038c36/attachment.html>

More information about the Haskell-Cafe mailing list