Forum Discussion
Hello arasi_m
Just to add on a little to what mrdwprice stated previously...
SELECT * FROM Table1 where TagId = ${#TestCase#TagId} and Time > '${#TestCase#FromTimeUTC}' and Time < '${#TestCase#ToTimeUTC}'
A nice feature that ReadyAPI provides is to 'right-click' in most any data entry field and choose the "Get Data" menu item. It allows you to gather the correct parameter replacement value from virtually anywhere in your project. In this case, doing that and picking the values from your Test Case area will get you the properties you can use.
Regards,
Todd
Thank you for the response. But i was facing the below error
Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: An error occurred during the current command (Done status 0). Conversion failed when converting date and/or time from character string.
When i used the query like this
SELECT * FROM Table1 where TagId = 4314 and Time > '${#TestCase#FromTime}'
Related Content
- 3 years ago
- 11 years ago
- 6 years ago