|
| |
|
|
AllenD
Posts: 258
From: Dayton, OH, USA
Status: offline
 |
Why is my database query case sensitive...? - 6/18/2001 16:54:00
I am using 2 database connections for a .dbf file and for a .fpt file to get the memo field. But when I query the database everything is case sensitive, it must be in CAPS, just how the original database file was generated...In CAPS...Unfortunately I cannot change the system generated database to lower case. Does anyone know how to convert a lower case query to an upper case one? I tried to format the text box to only upper case, and it does show the text in upper case only, but the query still searches lower case.
|
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Why is my database query case sensitive...? - 6/19/2001 20:39:00
In your query, add uCase() to surround the query input.
I must admit, its a first for me to hear that, but I dont do a lot of different database type work ![]("http://www.frontpagewebmaster.com/ubb/smile.gif") ------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
VP-ASP Shopping cart
| |
|
|
|
AllenD
Posts: 258
From: Dayton, OH, USA
Status: offline
|
RE: Why is my database query case sensitive...? - 6/19/2001 20:49:00
I am using the DRW for the search, would I modify the text box? Can you give me an example of the value for the text box? Thanks...
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
