FreeTDS Development Group

[Andrew Shuttlewood <andrew.shuttlewood AT futureroute.co.uk>]

On Tue, 2003-02-25 at 16:33, ZIGLIO Frediano wrote:
> > 
> > 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)