I have a problem updating an Oracle/Rdb database via ODBC. I can issues
a Select statement, but when I issue an update request , the SQL log shows
an error 'RDB-E.. cannot update while in a Read only transaction...The
method I am using is :

                  gDatabase.Execute "Update...", passthrough flag

I thought i could issue something like

            gDatabase.Execute "Set Transaction read write",passthrough
and then issue the update, and then commit. Alas this is not so.

How do you do transaction control in this situation???

                         Brendan

Make sure that you have a primary key on the table in oracle.