FreeTDS Development Group

["Mark J. Lilback" <mark AT lilback.com>]

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