Devart Forums

Bom dia.
Hoje atualizei o componente para a versão 8.1.4.
Desde então vem dando o erro: #42S22Unknown column 'BRASIL' in 'field list'.
Este erro dá nos campos que tem a Properties DefaultExpression preenchida.

Como posso resolver isto?

Good day.
Today updated the component to version 8.1.4.
Since then is giving the error: # 42S22Unknown column 'BRASIL' in 'field list'.
This error gives the fields that have the Properties DefaultExpression filled.

How can I fix this?

The behaviour of working with default field values was changed in MyDAC version 5.50.0.34. This was done to improve the support of default field values. In newer MyDAC versions default field values should be quoted, like this:
If you want to restore the old behaviour, you should set the DefaultExpressionOldBehavior variable (it is declared in the MemDS unit) to True. For this, you should use the following code in one of the units of your application:

Muito obrigado. Resolvi meu problema

Thank you. Solved my problem

You are welcome. Feel free to contact us if you have any further questions about MyDAC.