Submit and vote on feature ideas.

Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

DB Tool Returns a Value of 0

Options
reactancexl
reactancexl Posts: 160

I have a situation where I am comparing a Source DB Table (SQL Server) to another DB exposed thru a REST API. I get the data from souce and pass in query to the API to get the result and then do a diff on message. That part is working fine, however if the source column is of Datatype Integer and is Blank, SOATest returns a value of 0. This caused issues. I have done the isnull and cast to varchar to get result which works but the full xml tag is my isnull value I need it to be . Any quick suggestions? .thx

Tagged:

Tagged