Hi, I have some remote views on an oracle db. Oracle does not support boolean types in it's tables so all the boolean data in those tables is encoded with a CHAR(1) containing either 'T' or 'F'.

Is there anyway to have the remote views return .T. or .F. depending on the content of the field ?

I first tried adding an expression with the view builder : iif(boolField, true, false) as boolField but it added this with " in the sql code so it did not work.

I tried to create a view with such expressions by hands but the creation process does not work.

TIA