How do I get display value of a property via ODBC

Question

Question

Eduard Lebedyuk · Sep 28, 2016

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?

Discussion (3)0

Log in or sign up to continue

Brendan Bannon · Sep 28, 2016

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

2 1

score 3 · Answer 1 · 2016-09-28T11:56:00-04:00

Eduard Lebedyuk · Sep 28, 2016

I found out that %EXTERNAL can do it.

3 0

score 0 · Answer 2 · 2016-09-28T11:57:41-04:00

Eduard Lebedyuk · Sep 28, 2016

Thank you!

0 0