ADO Query is missing some records

JohnDesautels
JohnDesautels used Ask the Experts™
on
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.

Any ideas?

Thanks,

John
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi,

11 hex is equal to 17 decimal. Are you sure that your visualisation is correct?

Regards, Geo

Author

Commented:
Yes.

When they run a report based on the view they are missing the records.
He figured it out.

Delphi didn't like something about the way I was formatting dates in my view.

He changed my view from to_date('31-Jul-2003') to to_date('07/31/30','mm/dd/yy'). Now Delphi is able to pick up all the records.

John

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial