DB Checkpoint - How to avoid True/False conversion
The SQL Table (Microsoft SQL Server Management Studio) stores the value as 0 or 1, BUT the TestComplete DBTable converts it to True or False and stores it as True or False..
Thanks sonya_m for the explanation. Yes, what i was after was that the visual representation of the stored value and baselined value to be the same. To that effect i did create a support ticket and received a satisfactory/working solution to keep the data from converting when the column's datatype is 'bit' as below:
"I would like to first mention however that we discovered this conversion behavior is not caused by TestComplete, but is actually caused by the data provider TestComplete uses. If this same provider is used somewhere else, such as visual studio, then the same conversion behavior occurs."
To get around the conversion from the data provider, create a custom query so that the column uses the "Cast" command As an example:
SELECT
CAST(dbo.Bit_Test.Changing_Value as int) as COLUMN_NAME
FROM
dbo.Bit_Test