Results 1 to 5 of 5

Thread: Case sensitivity on filter

  1. #1
    erik Guest

    Case sensitivity on filter

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

  2. #2
    Frank Kwong Guest

    Case sensitivity on filter (reply)


    X.dbOptions="CaseSensitive=false"

    FK

    ------------
    erik at 3/23/01 8:35:41 AM

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

  3. #3
    Mark Guest

    Case sensitivity on filter (reply)

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

  4. #4
    Tim Davidge Guest

    Case sensitivity on filter (reply)

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

  5. #5
    Frank Kwong Guest

    Case sensitivity on filter (reply)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •