Urgent problem! Disappearing records.

[valtasar]

Hi all!

I have oracle 9.2.0.3.0, DOA 3.4.6.4

Query contains grouping from three unions.
I developed and tested it using SQL editor.
Everything works just fine. TOracleDataSet used.

Same query returns less records at run time!
Same text, same set of parameters, same values for them.

Also some of negative values misteriously dissapers from results!

I have no persistent fields, default session settings.

As I said everything is fine in SQL editor.
Even if I send that query to PLSD, it also provides correct results.

I have really hard times! Please help me, because project should be shipped yesterday. And that is only one problem I have.

Thanks on beforehand!

Mike

 

[valtasar]

Sorry!
Forgot to mention that execution time is also diffrerent.
At runtime it's MUCH faster then in SQL Editor or PLSD.

 

[valtasar]

Solved.