S
steve
All of my data is stored in Oracle tables. I created a search page in
Access to retrieve the selected information in these tables. The search
page is case-sensitive and I am trying to make it not so. The Oracle tables
view property is set to "uppercase", even though it saves the input data as
typed. How do I modify the search script to make it not case-sensitive or
to match the "uppercase" view of Oracle? I have tried formatting the search
page so that all entries are in uppercase and have also added the UCase()
argument to the search VB script, but neither have worked.
Access to retrieve the selected information in these tables. The search
page is case-sensitive and I am trying to make it not so. The Oracle tables
view property is set to "uppercase", even though it saves the input data as
typed. How do I modify the search script to make it not case-sensitive or
to match the "uppercase" view of Oracle? I have tried formatting the search
page so that all entries are in uppercase and have also added the UCase()
argument to the search VB script, but neither have worked.