Page 1 of 1
Generated SELECT ... FROM DUAL statemement
Posted: Mon 02 Oct 2017 11:04
by 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
Re: Generated SELECT ... FROM DUAL statemement
Posted: Tue 03 Oct 2017 13:15
by MaximG
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
Posted: Tue 03 Oct 2017 14:39
by ssette
MaximG wrote: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 !
Re: Generated SELECT ... FROM DUAL statemement
Posted: Tue 03 Oct 2017 15:32
by MaximG
We are glad you have localized the problem. Please contact us concerning ODAC usage.