I’m having trouble getting a transaction group to correctly use Boolean as the data type for a tag. The basic OPC items and Expression items whose data type is set to Boolean end up getting created in the database as int values instead of bits.
The OPC items themselves are individual bits of a DINT tag. I had expected that I would have to save them to the database as integers and then use a bit-mask to find the bit or bits I wanted from each one, but the OPC Browser allowed me to expand the DINT tag and get to the BOOL for each bit. But when I dragged the bits to the transaction group, they would show up as Int4 for the Data Type. I changed the Data Type to Boolean for each one, but when I enabled the transaction group for the first time, it created the table with all of the Boolean columns as int values instead of bit values. This also happened with an expression item I created which had a data type of Boolean, so I don’t know if it has anything to do with the Int4/Boolean mix-up.
Is this normal for transaction groups to write Booleans as ints instead of bits?
This is with 7.6.4-rc2, running against an MS SQL Sever database. The device in question is an Allen-Bradley CompactLogix.