FreeTDS Development Group

[ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>]

> > > 
> > > I have an SQL Query which is
> > > 
> > > {? = CALL [sp_insertCharacter](?)}
> > > 
> > > Which fails, and generates the following error (going through the
> > > disgusting error API)
> > > 
> > > Record number 3, error code = 00000 and error string =  
> Msg 170, Level
> > > 15, State 1, Server SQL, Line 1
> > > Line 1: Incorrect syntax near '='.
> > > 
> > > Note: this works with Microsoft's ODBC driver.
> > > 
> > > Is this unsupported in freetds? Or is there an 
> alternative syntax that
> > > should be used instead?
> > > 
> > 
> > IMHO this is a ms odbc bug...
> > Syntax so not allow spaces...
> > Try {?=call [sp_insertCharacter](?)}
> > or {?=call sp_insertCharacter(?)}
> 
> I've changed it to what you suggested (indeed, a direct 
> copy/paste jobby
> after modifying it myself didn't work) and I get
> 
> Record number 3, error code = 00000 and error string =  Msg 170, Level
> 15, State 1, Server SQL, Line 1
> Line 1: Incorrect syntax near '?'.
> 
> I get the same problems for both approaches (both with and without the
> []s)
> 

I added a test for this problem in HEAD. I replaced in BRANCH0_61 (just
copied over print.c, rebuild and execute print)

Attached test... it should work with your version

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================

Attachment: funccall.c.gz
Description: Binary data