Retrieve table filter from the filtered table?

Discussion in 'Questions (Windows Mobile)' started by LineCutter, Sep 7, 2008.

  1. LineCutter

    LineCutter Active Member Licensed User

    Is there a way to retrieve the table filter from the table, rather than the somewhat more inelegant method of saving it to a global variable every time it's changed?

    Scenario:

    sub pick_a_value
    'user picks a value & operator to filter table by
    'a="<5"
    o="<"
    f=5
    table1.filter("value"&o&f)
    Get_the_rest
    end sub

    sub Get_the_rest
    'This sub adds up the scores for all table entries apart from those already chosen
    'table1.filter("value<>"&a) 'Ooops, looks like we need 2 global variables!
    table1.filter("value<>"&f)
    DoTheMaths
    'Put things back as they were (for no real reason in this example)
    table1.filter("value"&o&f)
    end sub
     
  2. Ricky D

    Ricky D Well-Known Member Licensed User

    Doesn't look like it

    Doesn't look like you can.

    The Filter part of the table is a method that sets the filter. It's not a property like CaseSensitive or Cell .etc.

    regards, Ricky
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice