Re: [Sqlrelay-discussion] Invalid Column Name When Using Double Quotes Around an Update..Set Value

[Maciej W. <mac...@co...>]

I think it's not SQLRelay problem. Check QUOTED_IDENTIFIER setting in 
your SQL Server 7 it can be:
SET QUOTED_IDENTIFIER ON or SET QUOTED_IDENTIFIER OFF and it's about 
quotes handling
I think.

 > (sqlrelay > Sybase > SQL Server 7)
Sybase?

-- 
Maciej Wisniowski

Ben Gribaudo wrote:

> Hello,
>
> I'm still working on this Debian 3.1 box (sqlrelay > freetds > SQL 
> Server 7) and have encountered a strange error: An update query with 
> single quotes around the value works but using double quotes results 
> in sqlrsh reporting an invalid column name error. The column it says 
> it can't find is the *value* of the set statement. Stranger still, I 
> can copy-and-paste the double-quote query to a Debian 3.0 box 
> (sqlrelay > Sybase > SQL Server 7) and it works fine. Any ideas?
>
> Ben
>
> ==== Using double quotes around the value ====
> 0> update entity set name="Gribaudo3" where idnumber=183276;
> Server message:
>        severity(16)
>        number(207)
>        state(3)
>        line(1)
> Server Name:
> OBNTDEV01
> Procedure Name:
>
> Error:  Invalid column name 'Gribaudo3'.  <---- Notice that this is 
> the value to be set, not the column name.
>
> Attempted Query:
> update entity set name="Gribaudo3" where idnumber=183276
>        Rows Returned   : 0
>        Fields Returned : 0
>        System time     : 20000
>
> ==== Using single quotes ====
> 0> update entity set name='Gribaudo3' where idnumber=183276;
>
>
>        Rows Returned   : 0
>        Fields Returned : 0
>        System time     : 30000
>
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle 
> Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing 
> & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>