RemoteDB : with ORACLE - issue using the same parameter more than once (Delphi 11)

BIZ TMS RemoteDB
1

Hi,

I am having problem using, in ORACLE, querys that use the same parameter more than once. Ex:

SELECT * FROM TTTT WHERE DATAI >= :PDI AND DATAF <= :PDI

In MS SQL is working ok

I am using Delphi 11 Alexandria. In Delphi 10.4.2 is working ok

Kind regards,

Diego

2

Hello Diego, do I understand correctly that:

  1. In Delphi 10.4.2, it works fine with both MS SQL Server and Oracle?
  2. In Delphi 11, it works fine with MS SQL Server but not with Oracle?

Are you using the same TMS RemoteDB version in both Delphi versions?
And could you please let me know what is the exact wrong behavior and/or error message? What is "not working ok"?