Devart Forums

Hello.
I'm testing dotConnect (last version) with Visual Studio 2010 connecting directly to a Oracle 12 Server.
I've created several TableAdapters with queries without problems. But now I need to create a new one with a query that includes a CASE statement and I get an error on this return field. If I comment this case all works but uncommented throws an error when trying to crate the Fill method.
The exact format of case is:
CASE WHEN HMA.SITUATION = 'QOH' THEN 'Despatch' ELSE 'Return' END
And the error generated is:
SELECT clause error: expression near 'HMA'.
Cannot analyze the query text.

The same query (copy and paste) works perfectly on Oracle SQL Developer.
What I'm doing wrong?

I found more problems. The CAST function cannot pass the TableAdapter wizard check,

We could not reproduce the issue. Please provide the following information:
1. Full SQL statements, which reproduce the issue;
2. DDL scripts of objects required for these statements;
3. Oracle Client version, if you use the OCI mode;

Please also create and send us a small test project, which reproduces the issue.

Hello.
I've made some more tests and I've more problems
For example try this:
SELECT
'THIS IS A ' || ' TEST'
FROM
USE_ANY_TABLE

And the table adapter creator wizard fails. Points an error on |. Seems it cannot parse all Oracle semantic.
I use direct connection.

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.