03-31-2008 01:09 PM
04-01-2008 03:51 PM - edited 04-01-2008 03:52 PM
Vidula,
I am not completely sure if this is the cause of the error but it is something that will cause problems if it is not fixed. In your SQL statement you must properly concatenate your strings with your variables. In the statement you posted you were simply putting the variable names in the string, not actually pulling their values. To do so properly your query should look something like this:
"SELECT crc_table.CRC_Value FROM crc_table where crc_table.File_ID='"+Locals.File_ID+"' and crc_table.Version_ID = '"+ Locals.Version_ID+"' and crc_table.Link_ID = '"+Locals.Link_ID+"' ;"
This way we are using the values of the variables in conjunction with the text strings. In this case the usage of single quotes (') casts the variables as strings so you may need to change this character sequence, but from the second example you gave I think that your variables are of type string so this should work fine.
04-02-2008 10:12 AM
John,
I added the single and double quotes combination but still it's not working.
In the Build SQL Select Statement window there is one example under the Where Clause, it's difficult to make out from that example how to write the where clause in TestStand.
Some sort of documentation will really help here.
Thanks,
Vidula