I have created a view in Oracle 9i.
Another developer is using Delphi to get data from this view.
We are running the following query.
Select Count(*) from ora$myp.VW_COMMISSION_STMT_DETAILS
WHERE AgentNumber = '00006'
From TOAD, SQL Plus, Crystal Reports, etc. this query returns 17 records.
With Delphi it returns 11 records.