R
Ronald W. Roberts
We use Access as a way for users to run queries against a large Oracle
database.
The MS access DB's uses a standard OBDC Link to attach the tables.
So all the user has in their database are attached tables and standard MS
Access queries. None of these queries are pass-thru queries.
The problem is, a user just happen to be looking at the results of a query
and noticed a text field that had the last character of a 5 character field
truncated.
The value was 00794 and the query had 0079. When I opened the table that
contained this field, right mouse clicked and did a Filter For 00794,
I got all records displayed but showing 0079. I created a new query using
only that table and set the criteria to 00794, it produced a result
of all records displaying 0079 in the result datasheet.
When I use another MS access database or use Toad to display the record in
the table using 00794 as the criteria,
the correct value of 00794 is displayed. It's only displayed incorrectly in
this one database.
I know the Oracle database is correct because I can reproduce the correct
result using other tools or software to display the records.
Also, I can use the database in question and reproduce the incorrect answer.
Has anyone seen anything like this?
Thanks for any assistance provided,
Ron
database.
The MS access DB's uses a standard OBDC Link to attach the tables.
So all the user has in their database are attached tables and standard MS
Access queries. None of these queries are pass-thru queries.
The problem is, a user just happen to be looking at the results of a query
and noticed a text field that had the last character of a 5 character field
truncated.
The value was 00794 and the query had 0079. When I opened the table that
contained this field, right mouse clicked and did a Filter For 00794,
I got all records displayed but showing 0079. I created a new query using
only that table and set the criteria to 00794, it produced a result
of all records displaying 0079 in the result datasheet.
When I use another MS access database or use Toad to display the record in
the table using 00794 as the criteria,
the correct value of 00794 is displayed. It's only displayed incorrectly in
this one database.
I know the Oracle database is correct because I can reproduce the correct
result using other tools or software to display the records.
Also, I can use the database in question and reproduce the incorrect answer.
Has anyone seen anything like this?
Thanks for any assistance provided,
Ron