SqlDbx Forum

ajwoods

Member

SQL Statements Don't Work With Hyphenated Column Names

I am trying to run statements on tables with hyphenated column names, but doesn't seem to work. For example,

UPDATE myTable
SET myColumn = 1
WHERE "my-column" = 'SomeValue';

Get an error that says cannot find column "MY".  The column "my-column" is only recognized as "my".  Using ODBC connection.  Works fine with quotes in other SQL clients.

sqldbxhelp

Administrator

Re: SQL Statements Don't Work With Hyphenated Column Names

What database type you connect to through ODBC

ajwoods

Member

Re: SQL Statements Don't Work With Hyphenated Column Names

The database is Progress OpenEdge.

sqldbxhelp

Administrator

Re: SQL Statements Don't Work With Hyphenated Column Names

I am not sure what is going. We do no have access to Progress OpenEdge.
My suspicion that is has something to do with quoted identifiers.
SqlDbx does not set any ODBC options explicitly, so you can try to specify them in Options field in Login dialog

ajwoods

Member

Re: SQL Statements Don't Work With Hyphenated Column Names

Sorry,  the problem was specific to only a particular table in the database, and the software is fine, thanks for your help