I have a DBTable element which uses a query as datasource.
My db resides in Sql Server Express 2005.
All the values from this query have datatype as
I have modified the values in the dbelement and called Check method to compare the values with that in the database.
I have used the following routine.
set bic = dbtables.BICCollection
bic.Values(0, 1) = 5000
result = bic.Check()
The Check is giving an error "The "bicccdamt" field of row 0 contains a value type (Currency) that differs from the stored one (Smallint)."
How can I rectify this error??
This error means that your value (5000) was interpreted by default as a small integer. To make types match, you can use methods of the aqConvert object. In your case, you can use aqConvert.StrToCurrency:
<font class="small">Code:</font><hr /><pre>
bic.Values(0, 1) = aqConvert.StrToCurrency(5000)
Allen - SmartBear Support