Found a bug

[Infomaster]

Hi!

I found a bug in TOraQuery and TOraStoredProc classes (somewhere in their parent class maybe).

Try to make this:
1. Drop TOraSession component into the form.
2. Drop TOraQuery component into the form.
3. Link TOraQuery with TOraSession.
4. Make TOraQuery SQL.Text like this:

Code: Select all

SELECT 20.99 "TEST" FROM DUAL
UNION ALL
SELECT 20.99 "TEST" FROM DUAL

5. Make TOraSession connected.
6. Make TOraQuery active.
7. Drop TButton component into the form.
8. Make TButton.OnClick like this:

Code: Select all

OraQuery1.Filter := 'TEST = 20.99';
OraQuery1.Filtered := True;

9. Drop TDBGrid component into the form.
10. Drop TOraDataSource component into the form.
11. Link TOraDataSource to TOraQuery.
12. Link TDBGrid to TOraDataSource.
13. Run. Do you see a data in DBGrid? Now click on a Button.
You will see no data in DBGrid.
Why?
I want to ask you about this...

Thanks a lot.

[Plash]

Floating point values are not exact.

Set the FloatFilterDelta global variable from the MemData unit to a positive value. ODAC considers two numbers as equal if thier difference is not higher than FloatFilterDelta.