Skip to Content.
Sympa Menu

freetds - Re: [freetds] big commit: language command variable support added

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Mark J. Lilback" <mark AT lilback.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] big commit: language command variable support added
  • Date: Fri, 7 Mar 2003 08:32:41 -0500

At 7:59 AM +0100 3/7/2003, Frediano Ziglio wrote:
Why BITN are treated like numeric? Does ct_convert ignore destination
length for fixed types?

Yes. Pretty much every ctlib function is suppose to ignore destination lengths for fixed types.

Also, to support the same on TDS7/8: use mix prepare and execute code
and call sp_prepexec RPC (it do something like sp_prepare, sp_execute,
sp_unprepare), see code in query.c.

The links you sent on sp_executesql seem like the best solution. I was looking at changing the sql to include declare and sets for each variable, but that is a much better solution. More of a pain than what Sybase offers, but it should be workable.

--
__________________________________________________________________________
"They that can give up essential liberty
Mark J. Lilback to obtain a little temporary safety
<mark AT lilback.com> deserve neither liberty or safety."
http://www.lilback.com/ -- Benjamin Franklin




Archive powered by MHonArc 2.6.24.

Top of Page