FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

Hi,

I've found another freetds/sybase dblibrary behavioural difference, which I
am preparing a patch for.
But I thought I'd tell you about it before submitting the patch...

It seems that in sybase dblibrary you can do the following:

dbcmd(dbproc,"select getdate()"  ( or any query that returns a known number
of rows )
dbsqlexec()
dbresults()

for (known number of rows)
    dbnextrow()

dbcmd()
dbsqlexec()...

In other worrds, if you have fetched all the rows with dbnextrow, it is not
necessary to "complete" the results processing before submitting another
request.

We don't like this, and return a "...results pending.." error message

I've altered our code so that we behave the same as Sybase
However this has invalidated dblibrary unittests t0004 and t0005, which hope
to trap just this circumstance.

regards,

¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤

Bill Thompson
Securities Services Division
Merrill Lynch Europe

For very important information relating to this e-mail please click on this
link:  http://www.ml.com/legal_info.htm