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
Generated SELECT ... FROM DUAL statemement
Re: Generated SELECT ... FROM DUAL statemement
Please provide the sample of the used query, as well as the macro value, which is present in this query
Re: Generated SELECT ... FROM DUAL statemement
Just found the problem !MaximG wrote:Please provide the sample of the used query, as well as the macro value, which is present in this query
A Field with a (wrong) DefaultExpression ... IT instead of 'IT'
Let me say, very very difficult to found !
Re: Generated SELECT ... FROM DUAL statemement
We are glad you have localized the problem. Please contact us concerning ODAC usage.