SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Different SQL statement for oracle.jdbc.OracleDriver and VBA@ADO

FrankieBAug 26 2018 — edited Sep 21 2018

Hello Experts,

i'm wondering about two different scenarios while executing exactly the same sql statement.

Here is the statement:

SELECT COUNT(*) AS Counter FROM MOVEMENT WHERE (MOV_CTIME BETWEEN '25.07.2018' AND '30.07.2018') AND MOV_TYPE='K' AND MOV_SRC_LOC_CODE LIKE 'L1MT%'

It works perfectly with the Java odbc driver directly from Oracle (JDBC@DBeaver Client) but not with VBA@Excel.ADO. I both cases i'm getting a recordset with one record which is correct in the

first case and 0 in the second.

So why is that?

Somebody has a solution?

Thanks for support

Frankie.

This post has been answered by BEDE on Aug 27 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 19 2018

Added on Aug 26 2018

5 comments

427 views