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

[Ben G. <me...@be...>]

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