Help with odbc driver connected OK. But dash in table/column

Posted by Admin on 22-May-2009 09:51

Hello.  I have an issue with Visual Studio. I can connect to the progress odbc, But due the dash (-) in the table names

& field names, I keep getting sql errors.

The sql statment for v.s must be in a double quoted string. So I can not use the double quotes on the table or column name.

If i use single quotes, on a table name, I get an error, If i use them on a column name, No error, But also no data returned.

Please offer advice.

Thank You.

All Replies

Posted by Admin on 22-May-2009 10:34

Thanks..

But I have found the answer.

sql =

"SELECT * FROM pub.team where " & (System.Convert.ToChar(34)) & "team-type" & (System.Convert.ToChar(34)) &

" = 1"

Thanks.. Bob

This thread is closed