freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Michael Peppler <mpeppler AT peppler.org>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] new dblibrary issue
- Date: 14 Feb 2003 10:26:47 -0800
On Fri, 2003-02-14 at 08:36, Thompson, Bill D (London) wrote:
> 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.
Yes, this is where dbresults() and ct_results() differ. With dbresults()
if you *know* that yours is the only result set then you only need to
fetch all the rows in that result set. With ct_results() you always have
to call it until it stops returning CS_SUCCEED.
Michael
> --
> Michael Peppler Data Migrations, Inc.
> mpeppler AT peppler.org http://www.mbay.net/~mpeppler
> Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
> long term contract positions - http://www.mbay.net/~mpeppler/resume.html
-
[freetds] new dblibrary issue,
Thompson, Bill D (London), 02/14/2003
- Re: [freetds] new dblibrary issue, Michael Peppler, 02/14/2003
- <Possible follow-up(s)>
-
RE: [freetds] new dblibrary issue,
Lowden, James K, 02/14/2003
- RE: [freetds] new dblibrary issue, David Owen, 02/14/2003
Archive powered by MHonArc 2.6.24.