Board index » delphi » D1: DBF & Non-Case Sensitive Indicies

band...@vitrex.net (Mike Bandor)

Delphi Developer
Mon, 19 Mar 2001 03:00:00 GMT

D1: DBF & Non-Case Sensitive Indicies

Is there a way, under D1 and using Dbase for Windows formated database
files, to create an index that IS NOT case sensitive?

Thanks.

Mike

------------------------------------------------------
- Mike Bandor  (band...@vitrex.net)
- Software Engineer:    Delphi/Ada/C++/Java/Win3.1/
-                       Win95/Winhelp/JOVIAL/MASM
-                              
- "Trying to manage programmers    
-  is like trying to herd cats!"          
-
- Speaking for myself!  Standard disclaimer applies.
------------------------------------------------------
- Author of MEGATERMS:  Military Terms and Acronyms
- http://www.vitrex.net/~bandorm/megaterm/megaterm.htm
- ftp://vitrex.net/usr/b/bandorm/m-term.zip
------------------------------------------------------

 
Anatoly Podgoretsk

Delphi Developer
Tue, 20 Mar 2001 03:00:00 GMT

Re:D1: DBF & Non-Case Sensitive Indicies


Hi Mike!

Yes possible, use expression indexes like

UPPER(Field_Name)

--
Sincerely yours
Anatoly Podgoretsky
n...@vnet.ee

Quote
Mike Bandor wrote in message <3612d0bd.605...@news.vitrex.net>...
>Is there a way, under D1 and using Dbase for Windows formated database
>files, to create an index that IS NOT case sensitive?

>Thanks.

>Mike

>------------------------------------------------------
>- Mike Bandor  (band...@vitrex.net)
>- Software Engineer:    Delphi/Ada/C++/Java/Win3.1/
>-                       Win95/Winhelp/JOVIAL/MASM
>-
>- "Trying to manage programmers
>-  is like trying to herd cats!"
>-
>- Speaking for myself!  Standard disclaimer applies.
>------------------------------------------------------
>- Author of MEGATERMS:  Military Terms and Acronyms
>- http://www.vitrex.net/~bandorm/megaterm/megaterm.htm
>- ftp://vitrex.net/usr/b/bandorm/m-term.zip
>------------------------------------------------------

Other Threads

1. D1: DBF & Non-Case Sensitive Indicies

2. Is SQL non case sensitive possible?

3. D1, dbf - refreshing grids in multi-instance (multi-user) case

4. Case Sensitive vs Case-InSensitive

5. Help: FindFirst, Case-sensitive?

6. Like statement case sensitive on Memo field

7. Case Sensitive in Foxpro/Delphi

8. DB Text search case-sensitive?

9. SQL case sensitive

10. HELP Case-Sensitive Indexs