When I do a "SELECT * ..." from a certain table, I get a normal result with rows and column headers. One column header reads "Resource", but when I do a "SELECT Resource FROM ..." I get Syntax error in SQL statement at or about "Resource FROM PUB.ActOper WHERE CreDate " (10713). It's a Progress database.
Yes, that was it. How silly of me. Thank you. But when you solve one problem, along comes the next. According to the Progress SQL reference "you can use keywords as identifiers in SQL statements only if you delimit them with double quotation marks".
But I can't find the right syntax to use in my ASP.NET page. Double and single quotation marks are not interchangeable it seems. This will not work: Dim comm As New OdbcCommand('SELECT "Resource" FROM PUB.Table', conn)
Does anyone know the correct way to write this sentence?