Hi,
I am using a MS access mdb file to display some record from oracle database using odbc connection.
But it is giving wrong result sometimes. below is the scenario:-
I have a table (linked table) called map_detail in mdb as well as oracle with same table structure.
I formed one query in mdb (sql query) select * from map_detail where batch_no="SSO15121".
It is always fetching some other result, but when I am changing the query by changing the batch no "SSO15148"
it is working fine. I noticed that for cases it working.
Any help will be highly appreciated. Thanks in Advance
Regards
Amlan Roy