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.
Thanks for your help,