Visual Studio 2010 - CASE Statement

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
disproquima
Posts: 3
Joined: Thu 26 Jan 2017 13:00

Visual Studio 2010 - CASE Statement

Post by disproquima » Thu 26 Jan 2017 13:10

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?

disproquima
Posts: 3
Joined: Thu 26 Jan 2017 13:00

Re: Visual Studio 2010 - CASE Statement

Post by disproquima » Thu 26 Jan 2017 16:28

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

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Visual Studio 2010 - CASE Statement

Post by Pinturiccio » Fri 27 Jan 2017 16:46

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.

disproquima
Posts: 3
Joined: Thu 26 Jan 2017 13:00

Re: Visual Studio 2010 - CASE Statement

Post by disproquima » Thu 02 Feb 2017 15:41

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.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Visual Studio 2010 - CASE Statement

Post by Pinturiccio » Mon 06 Feb 2017 12:07

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

Post Reply