SQL server to Oracle
Posted on 2002-07-29
i have a system which is developed using vb and connected to Microsoft SQL Server database. it is fine. but now i need to make the system compatible with oracle.
i hit a problem when i try to update a field of a recordset that select records from 2 or more table using this sql :
set rs = Conn.Open("Select Table1.column1 from Table1, Table2 where Table1.Column2 = Table2.column2")
when i do a vb statement like this:
rs!column1 = "1"
I get this error message.
"Run-time error '-2147467259 (80004005)'
ROW-00009: Cannot update row in a read only rowset"
i didn't get this message if i select the record from only 1 table. i know i can solve this if i change the sql but i will need to change a lot of codes for that.
i have already try using different cursor type and different lock type for vb but it still doesn't works. any help will be much appreciated. thanks.