FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

A (b|st)acktrace of the bus error should allow it to be pinned down pretty 
quickly.  I know I've squashed some on solaris in years past but newer 
code may not handle alignment correctly.

Brian  

On Fri, 13 Dec 2002, Lowden, James K wrote:

> > From: Harrison, Bruce (CXO) [mailto:Bruce.Harrison AT hp.com]
> > Sent: December 13, 2002 10:53 AM
> >
> > >You would not have liked doing this in tds.  Also, particularly for
> > >something simple like this, I think you'll find db-lib easy to grasp.
> > 
> > Actually I had it working on Linux (using the tds library), with the
> > build (non-snapshot) that I pulled on Nov. 22.  The SQL query 
> > that I was sending (and its output) is as follows:
> > 
> > declare @case_id varchar(15)
> > declare @case_status varchar(7)
> > exec test_feeder 'Cleared','LEG','test_node','CIM:test','Add. Text
> > Here','harrison',@case_id output,@case_status out
> > select @case_id AS 'Case Id', @case_status AS 'Case Status'
> > Case Id Case Status
> > 036361-120402   Updated
> 
> Bruce, 
> 
> I see.  I took you literally when you said, "getting a single row (actually
> two output variables)".  Your example above is really 2 queries: "exec
> test_feeder..." and "select @case_id...".  The latter returns an ordinary
> result set.  Nothing tricky about that, all the APIs can do it.  
> 
> > It sounds as if db-lib is the API that I should be using 
> > rather than the ct-lib API????
> 
> No.  db-lib has the rpc functions that let you read the output parameters
> without a subseqent select statement, but you don't need that feature.
> (Although you use it, if you wanted to.)  ct-lib will do you fine.  As you
> like.  You might want to look in src/ctlib/unittests for examples.  
> 
> Any luck on the bus error?  I live in New York, where there's talk of a
> transit strike.  That would be a bus error of another order.  
> 
> Regards, 
> 
> --jkl
> 
> 
> 
> 
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above.  If you are not the intended recipient, or an employee or agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this communication is
> strictly prohibited. If you are not the intended recipient, please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that we do not accept account orders and/or
> instructions by e-mail, and therefore will not be responsible for carrying
> out such orders and/or instructions.
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>