Unanswered: Update Quoted Field in ORACLE Using ADO
I have a database table that has a field named "Source". I created the field with quoted identifiers since Source is a reserved word. I have a VB app that selects rows from this table and performs an update on the "Source" field using an ordinal position in the recordset.
sql = "SELECT ""Source"" FROM ""DSRACTVYGUIControls"" WHERE ""ControlName"" = 'MyNewComponent_Src1Agg'"
rs.Open sql, conn, , , adCmdText
While Not rs.EOF
rs(0) = Replace(rs(0),"SEARCH", "REPLACE")
The problem comes when I call the update. I receive the error:
[Oracle][ODBC][Ora]ORA-00904: invalid column name
It would seem that ADO is not using the quoted identifiers when it trys to perform the update. Does anyone have any thoughts on this? Is there an option in the connection or recordset object that I need to set?
I know that I could just use an update query, but I would really like for the update to be performed through the ado recordset since this works with other databases and I have this trype of scenario many places in my code.
Renaming the column is not an option. The field can be setup and accessed using quotes. In my digging I have also found out that the field can be created using all uppercase and quotes and then referred to as all uppercase without the quotes.
This seems to work for most reserved words except Comment. When you refer to COMMENT you must use quotes around it.