how to update test status using TDConnection

[patelpradeep]

hi,

i have added one extra field into Test Status list for user environment errors "ENVERR" using project settings.
I m writing VAPI scripts for automation using vbscript.

If the automation tests has any test environment error i want to set the Status to ENVERR.

I am using this code to set the value but it has no effect, the run automatically sets the value to either Failed or Passed only.

----------------------------------------

Code:

Set com = TDConnection.Command
  com.commandText="update testcycl set TC_STATUS='"& "ENVERR" &"' where TC_CYCLE_ID ="& CurrentTestSet.Id & " AND TC_TEST_ID="& ThisTest.Id
com.execute

--------------------------------------

i also tried setting the status with these commands but no success.

Code:

CurrentRun.Status = "No Run"
   CurrentTest.Status = "No Run"

Can someone please guide me?

Thank you,