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.
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