I am working with QC 11 and Oracle DB 11g
I am trying to update a field in the QC Database.
A select query works fine but im unable to update data.
Here is my code:
<font class="small">Code:</font><hr /><pre>
Set cmd = TDConnection.Command
cmd.CommandText = "UPDATE TEMP.T_Typ_Kunde SET used = 'abc' WHERE ID = 1"
TEMP is a scheme on which the QC User has access.
If i execute the Query directly in the database its works well.
It is very ill-advised to attempt to update data directly in the database using query languages. You should be using the OTA API to ensure data integrity.
(Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)
I know but I work only on a test environment, so it is no problem.
By the way, I solved the problem.
The QC user had only select rights on the TEMP scheme -.-
Is this the query you run in QC workflow? have you tried the query without the schema name? you should first connect to the schema in your code and then there is no need to use the schema name.