Access fieldname DISTINCT does not work

[Bob]

I have a microsoft access fieldname DISTINCT, which is not very smart, but to late to change it now. This used to work using TADOQUERY but does not work using TUNIQUERY.

query.fieldbyname('distinct').asstring := 'YES'

When you goto post the record is when it fails with no error message.

Is their a work-around? I've tried referencing by index and that did not work either.

[bork]

Hello

You should set the property Options.QuoteNames to True for TUniQuery or TUniTable.