AnsweredAssumed Answered

AF Table lookup returns bad quality indicatior

Question asked by UlrichRuediger on Aug 12, 2020
Latest reply on Sep 3, 2020 by UlrichRuediger

I'm looking through AF-Table lookup on an attribute in an MS-SQL database
"SELECT PRODUCT NAME FROM [CAS_MES_DSE.Teilanlage_V] WHERE [TEILANLAGE_NAME] = 'V201_BE01_RA001'"

This access returns a "Bad" for the Quality Indicater.
It has a value of "Test" and is declared as nvarchar2 (40).
In AF the attribute is declared as a string
Another attribute with the same declaration gives a correct result
"SELECT [CHARGEN_NR] FROM [CAS_MES_DSE.Teilanlage_V] WHERE [TEILANLAGE_NAME] = 'V201_BE01_RA001'"

The difference is that the square brackets are removed the first time you select after editing.

Does somebody has any idea

Thanks in advance

Outcomes