on 04-11-2018 9:14 AM
I discovered that my DF is not getting pushed down to database server and the reason is I was using IfThenElse function which can not be converted to equivalent SQL by DS.
After hours researching, I found out that this issue can not be resolved because I'm setting my datastore like this :
In order to convert IfThenElse function to SQL, the option IfThenElse support must be Yes, but only when I set the Database Type to ODBC, that option appears.
My question is, Why isn't IfThenElse get pushed down if datastore's Database type wasn't ODBC ?
User | Count |
---|---|
82 | |
11 | |
10 | |
8 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.