freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

RE: [freetds] Is it possible to start another query onaconnectionprovided that not all rows of a previousselectstatement arefetched?

From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Subject: RE: [freetds] Is it possible to start another query onaconnectionprovided that not all rows of a previousselectstatement arefetched?
Date: Thu, 7 Oct 2004 16:07:52 +0200

>
> The only thing I would dare to insist on is that MS ODBC
> driver works after
> N SQLFetch calls, i.e. the last call returns 0 and everything
> is fine after
> that. The FreeTDS requires N+1 SQLFetch calls. I do not
> consider this as a
> problem - it is for your information only.
>

However you program don't speak to FreeTDS directly but with DM. I can
fix this issue for our driver however for example unixODBC wouldn't
change the state so it would return still invalid state. Note also that
ms bevaviour should change if there is another result after last row.

freddy77

RE: [freetds] Is it possible to start another query onaconnectionprovided that not all rows of a previousselectstatement arefetched?, ZIGLIO, Frediano, VF-IT, 10/07/2004