In your linked query sql statement, have you tried converting the values to a single canonical UOM for pressure?
Thanks for your quick reply.
The answer is: No.
And I think I do not want to. I want AF to do the conversion. Ideally AF would be the single unit conversion engine in my architecture.
I did some further investigation.
At first I thought maybe it's fixed in 2010. And I started a new 2010 database on my 64 bit laptop, and everything worked. Then I took that database and imported it into my failing one Windows 2003 server based installation (so that's from 2010 down to 2.1) and it still worked.
I thought maybe the order of creation was important, so I added a new attribute to my template, and configured the table lookup reference but still it did not work.
I have found no differences between linked tables and "manual" ones.
I do not know how to attach my database export to this post.
If I understand the problem correctly, this should be possible. Lets make it simple. Given a table with two column, string ID and string Pressure. Also, you have an element with two attributes: EquipmentID and PressureReading. You would like to configure a tablelookup DataReference that returns the Pressure column into the PressureReading Attribute.
If so, that table lookup for the PressureReading attribute should be configured like so:
SELECT Pressure FROM MyPressureTable WHERE ID = @EquipmentID
As long as the Attribute type is float/double, and the attribute has a UOM of the same class, the data will be brought into the attribute.
@Jan: as a side and friendly note, and mostly for future reference, this is more of an end-user/system configuration question, and these are normally handled through our regular technical support team. No offense to Chris and Paul (they're the best!!), but tech support is generally better equipped (and staffed) to answer these kinds of question... they could even help you via a WebEx session, etc. If you were to develop using the AF SDK, then this forum is definitely your best bet! Just trying to help make the most out of the resources available to you