FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> 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.