Is there a way to remove case sensitivity on filtering??
Printable View
Is there a way to remove case sensitivity on filtering??
X.dbOptions="CaseSensitive=false"
FK
------------
erik at 3/23/01 8:35:41 AM
Is there a way to remove case sensitivity on filtering??
Erik,
Try dbFilterParams = "CaseSensitive=false"
Please tell us what database (SQL, ORACLE, etc) you are using and if you get it to work. Others will BENEFIT from your feedback. THANKS!
Mark.
------------
Frank Kwong at 3/23/01 8:49:22 AM
X.dbOptions="CaseSensitive=false"
FK
------------
erik at 3/23/01 8:35:41 AM
Is there a way to remove case sensitivity on filtering??
Mark,
I've tried this setting and can advise it fails using DB2. The following error results:
Error # (Get_RS_OPEN - TOPSQL - SELECT Field1,Field2,Field3,Field4,Field5 FROM ONEDAY_RESULTS_DJIA WHERE UPPER(Field1) > 10 AND UPPER(Field2) = 100 AND UPPER(Field3) > 1.5 AND UPPER(Field4) LIKE '%TEST%' AND UPPER(Field5) = 001) = 80004005(-2147467259)
Description = [IBM][CLI Driver][DB2/NT] SQL0440N No function by the name "UPPER" having compatible arguments was found in the function path. SQLSTATE=42884
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 42884
Native Error = -440
This would indeed be a very valuable feature if able to get it to work.
Cheers,
Tim
------------
Mark at 3/26/01 8:57:29 AM
Erik,
Try dbFilterParams = "CaseSensitive=false"
Please tell us what database (SQL, ORACLE, etc) you are using and if you get it to work. Others will BENEFIT from your feedback. THANKS!
Mark.
------------
Frank Kwong at 3/23/01 8:49:22 AM
X.dbOptions="CaseSensitive=false"
FK
------------
erik at 3/23/01 8:35:41 AM
Is there a way to remove case sensitivity on filtering??
What is the DB2 function to convert a field to upper case ?
FK
------------
Tim Davidge at 3/31/01 2:34:12 PM
Mark,
I've tried this setting and can advise it fails using DB2. The following error results:
Error # (Get_RS_OPEN - TOPSQL - SELECT Field1,Field2,Field3,Field4,Field5 FROM ONEDAY_RESULTS_DJIA WHERE UPPER(Field1) > 10 AND UPPER(Field2) = 100 AND UPPER(Field3) > 1.5 AND UPPER(Field4) LIKE '%TEST%' AND UPPER(Field5) = 001) = 80004005(-2147467259)
Description = [IBM][CLI Driver][DB2/NT] SQL0440N No function by the name "UPPER" having compatible arguments was found in the function path. SQLSTATE=42884
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 42884
Native Error = -440
This would indeed be a very valuable feature if able to get it to work.
Cheers,
Tim
------------
Mark at 3/26/01 8:57:29 AM
Erik,
Try dbFilterParams = "CaseSensitive=false"
Please tell us what database (SQL, ORACLE, etc) you are using and if you get it to work. Others will BENEFIT from your feedback. THANKS!
Mark.
------------
Frank Kwong at 3/23/01 8:49:22 AM
X.dbOptions="CaseSensitive=false"
FK
------------
erik at 3/23/01 8:35:41 AM
Is there a way to remove case sensitivity on filtering??