KS-Soft wrote:Value of the database field that you need to check is displayed in Reply field of the test so you may use %Reply% macro variable.
You may also use %Reply_CStyle%, %Reply_Number% or %Reply_Integer% when necessary.
PS I think you may create select request that will join several database fields into one value...
Regards
Alex
Alex,
What I'm trying to do is integrate with our hosting provisioning system and I need a way to delete tests once a customer closes a hosting service on their account.
I have an ODBC SQL test that does -
Code: Select all
select top 1 new_test_id from hmlog_modifytestsqueue where completed = 0 AND action='delete'
This will return a single row with a single column, however the value that is in the database (there's only one record at the moment) isn't being parsed into the
%Reply% macro. I get a single digit integer value which looks like the time taken the execute the query in milliseconds(?)
(nb: please don't confuse the
new_test_id field name with the HM Test ID, they're not related, it's actually a value generated by our system that forms part of the test name/title)
In my HMS Script, which is called when the test is good, I'm doing the following:
Code: Select all
DeleteTest %Reply%-Ping
DeleteTest %Reply%-URL
ExecuteProgram 10000 c:\HM\SetDeleteTestCompleted.exe %Reply%
The reason for this is that the test import text file seems to ignore the
DeleteTest command.
The other way I could do this is to call a simple webservice using a URL test and return the
new_test_id I'm trying to delete in the
%HttpPage% macro, but this is a bit more work.
Thanks again for your time.
Kevin