Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: RE: DBlib bcp in/out sample
Date: Aug 25 1999 2:19PM
Ravipudi, Murali writes:
> Yes, I am already using it that way.
> My code is like :
> dblib : create temp table
> dblib : call stored proc ( which fills this temp table)
> system : bcp the data out from the temp table
> dblib : clear the temptable ( not necessary, but in future there will be
> more actions added after this. )
> and I wanted to do the bcp also using dblib, rather than using the back
> In the above sequence, I am getting a "Sybase error: Attempt to initiate a
> new SQL Server operation with results pending." when the bcp is called.
> that is why !! ?? !! ??
Because you are not flushing all the results (calling dbresults() in a
loop as you should, until it returns NO_MORE_RESULTS)
Michael Peppler -||- Data Migrations Inc.
firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: email@example.com