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.
I would really recommend doing an update statement - it is faster and you can reuse it. If you still want to persue the other option, how do you set a quoted identifier to true in oracle ? In Sql Server you can use a transact sql statement "SET QUOTED_IDENTIFIER ON" - is this possible in oracle ?