I have a requirement in our report which is as follows:
1.Insert some data to a temporary table
2.And then get data from that temporary table and display in the report.Both insert and select should happen in the same session.
I tried this using ODBC(RDO) connection by creating a system DSN.But it gives the below error :
"may not perform insert/delete/update inside a read only transaction"
I had set the Read-only connection for System DSN as 'False' but still getting the above error.
Which connection has to be used for the above scenerio?