Eduard Lebedyuk · Sep 28, 2016

How do I get display value of a property via ODBC

I have a class with a string property with DISPLAYLIST and VALUELIST parameters specified.

When I query this class via ODBC I receive logical value as it is and not a display value.

Is there any way (without stored procedure) to get display value?

0 461
Discussion (3)0
Log in or sign up to continue

I am not a fan of this behavior but the LogicalToOdbc method does not convert the ValueList to DisplayList like the LogicalToDisplay method does.

You have 2 Options:

1) you can use %External(FieldName) in the  query, that will give you the DislayList value

2) you can write your own LogicalToOdbc method that does the same as the LogicalToDisplay does