Hi,
We recently added a field to an external object and included that field in the update statement. The field we created in M-Files is a Boolean, the field in the external source is numeric, but truly is a Boolean (I don't have control over the external system data types). When going updating the new field, it throws an error about the data types. The format of the update statement in the external connection is below:
Update ExampleTable Set ExampleField1 = ?, ExampleField2 = ? where ExampleID = ?
Can I customize the update statement to be something like this? My attempts to do this don't seem to be working.
Update ExampleTable Set ExampleField1 = ?, ExampleField2 = iif(? = True, 1 , 0) where ExampleID = ?
