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?
Visual Studio 2010 - CASE Statement
-
- Posts: 3
- Joined: Thu 26 Jan 2017 13:00
Re: Visual Studio 2010 - CASE Statement
I found more problems. The CAST function cannot pass the TableAdapter wizard check,
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Visual Studio 2010 - CASE Statement
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.
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.
-
- Posts: 3
- Joined: Thu 26 Jan 2017 13:00
Re: Visual Studio 2010 - CASE Statement
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.
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Visual Studio 2010 - CASE Statement
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.