Generated SELECT ... FROM DUAL statemement

[ssette]

I have a problem with a TSmartQuery component. Calling the Append method the Dataset generates (or at least the monitor says) a SELECT ... FROM DUAL statement. This is not the statement generated to handle sequence but a statement like this SELECT IT FROM DUAL, where IT seems to be a value of a Macro defined in the dataset.
Do you hava any idea on why the dataset sends this statement ?

TIA

Sergio Sette

[MaximG]

Please provide the sample of the used query, as well as the macro value, which is present in this query

[ssette]

Please provide the sample of the used query, as well as the macro value, which is present in this query

Just found the problem !
A Field with a (wrong) DefaultExpression ... IT instead of 'IT'
Let me say, very very difficult to found !

[MaximG]

We are glad you have localized the problem. Please contact us concerning ODAC usage.