Select Query NOT returning Data

[RFranks]

I am having an problem with the OracleQuery component. I am dynamically creating SQL, using the query.ADD method and then query.EXECUTE. It works most of the time, but some queries with certain data do not bring back any data when they should (I can copy the query to SQLPLUS and it works). I have found that by adding spaces into the query string it will start working! I.e no change to the query itself.

I am using Delphi 5, DOA v3.4.6.4

 

[Marco Kalter]

I have never heard of such a problem before. Can you send me a demo to reproduce this?

------------------
Marco Kalter
Allround Automations

 

[valtasar]

Hi RFranks!

Seems like I have similar problem.
Did You find any solution?

 

[RFranks]

I have now traced this problem to our code which was submitting the SQL. Closed

 

[Marco Kalter]

Okay, thanks for letting me know.

------------------
Marco Kalter
Allround Automations