Devart Forums

Component MSQuery Options.DefaultValue=False. Some fields have DefaultExpression=aaaaa
WITHOUT quotes!!
When I try to add record I get error
The multi-part identifier "aaaaa" could not be bound.
In Profiler I see
SELECT aaaaa , aaaaa
If I set DefaultExpression='aaaaa' (with quotes) It's OK.

Hello,

Such behaviour is correct. SDAC allows using server functions in the DefaultExpression property. That's why you should quote the string value in the DefaultExpression property.

Thanks. It's OK.