Skip to Content.
Sympa Menu

freetds - RE: [freetds] ODBC ExecDirect statements broken

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] ODBC ExecDirect statements broken
  • Date: Thu, 6 Nov 2003 13:59:12 +0100

>
> Hi guys,
>
> A recent check-in appears to have broken use of the
> ODBC SQLExecDirect() where the query uses '?'
> tokens for parameters.
>
> e.g. "SELECT * FROM MyTable WHERE Key = ?"
>
> This works perfectly using prepared queries, but produces
> this error with SQLExecDirect:
>
> [FreeTDS][SQL Server]Line 1: Incorrect syntax near '?'.,
> SQLSTATE=42000
>
> I'm using FreeTDS code checked-out an hour ago.
> (N.B. This problem occurs with and without a driver manager,
> so it's nothing to do with that recent interest of mine :-)
>
> My test code has worked for months with prepared and direct
> queries and is unchanged for months, hence my assumption that
> the problem is due to a recent check-in.
>
> Cheers,
>
> David
>

Hi David!
If you send your test code we will integrate in our unittests so in
future you are sure they will run correctly.
What server/tds version are you using ?

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page