Skip to Content.
Sympa Menu

freetds - [freetds] new dblibrary issue

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] new dblibrary issue
  • Date: Fri, 14 Feb 2003 16:36:30 -0000

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






Archive powered by MHonArc 2.6.24.

Top of Page