Case sensitivity on filter

[erik]

Is there a way to remove case sensitivity on filtering??

[Frank Kwong]

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]

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??

[Tim Davidge]

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??

[Frank Kwong]

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??