I have this code:
RunID = Run_Fields("RN_CYCLE_ID").Value
Set comm = eSigTD.Command
comm.CommandText = "SELECT TC_STATUS FROM TESTCYCL WHERE TC_CYCLE_ID = '" & RunID & "'"
Set rs = comm.execute
Basically I'd like the following to happen but don't know how to code it:
IF Passed is in rs && Not Completed is in rs THEN Update a custom field with Not Completed
I can update the custom field but I don't know how to see if Passed or Not Completed is in the array.
Any help would be greatly appreciated. Thanks in advance!
Re: In Array?
First,I doubt that you can retrieve anything meaningful with the SQL command you're using : you get a run id and then select the status of tests in test sets for which the test set id is equal to the run id...
Then you should try to avoid the use of the Command object and SQL statements: such a code may not work with future versions of QC, and the Command object is disabled by default for most users.
Finally, you are not clear as to where the custom field is supposed to be : is it a user defined field for test sets ?