F francisco cobos Member Licensed User Longtime User May 31, 2007 #1 How can I make a filter in table with a number variable? ' instead of: Table1.Filter("posx = 118") I want to use: '******************** a = 118 Table1.Filter("posx" & " '< a'") ' but it doesn't work '*********************** any idea? Thanks in advance
How can I make a filter in table with a number variable? ' instead of: Table1.Filter("posx = 118") I want to use: '******************** a = 118 Table1.Filter("posx" & " '< a'") ' but it doesn't work '*********************** any idea? Thanks in advance
RandomCoder Well-Known Member Licensed User Longtime User May 31, 2007 #2 Try one of these two methods.... a = 118 Table1.Filter("posx" & a) ' should filter using value posx118 OR a = 118 posx="posx"&a Table1.Filter(posx) ' should filter using value posx118 Sorry but I'm working at the moment and don't have time to test myself. Regards, RandomCoder
Try one of these two methods.... a = 118 Table1.Filter("posx" & a) ' should filter using value posx118 OR a = 118 posx="posx"&a Table1.Filter(posx) ' should filter using value posx118 Sorry but I'm working at the moment and don't have time to test myself. Regards, RandomCoder
B BjornF Active Member Licensed User Longtime User May 31, 2007 #3 You could write it all into one: a = 118 Table1.Filter("posx <" & a) (Randomcoder - I think you might have missed the "<" in your example ) all the best / Björn
You could write it all into one: a = 118 Table1.Filter("posx <" & a) (Randomcoder - I think you might have missed the "<" in your example ) all the best / Björn
specci48 Well-Known Member Licensed User Longtime User May 31, 2007 #4 Just look at old threads/posts or use the search utility: http://www.b4x.com/forum/showthread.php?t=163&highlight=filter specci48
Just look at old threads/posts or use the search utility: http://www.b4x.com/forum/showthread.php?t=163&highlight=filter specci48
RandomCoder Well-Known Member Licensed User Longtime User May 31, 2007 #5 How can I make a filter in table with a number variable? ' instead of: Table1.Filter("posx = 118") I want to use: Click to expand... (Randomcoder - I think you might have missed the "<" in your example ) Click to expand... BjornF, well spotted. But in actual fact it was an = sign that I missed :signOops: Regards, RandomCoder
How can I make a filter in table with a number variable? ' instead of: Table1.Filter("posx = 118") I want to use: Click to expand... (Randomcoder - I think you might have missed the "<" in your example ) Click to expand... BjornF, well spotted. But in actual fact it was an = sign that I missed :signOops: Regards, RandomCoder
F francisco cobos Member Licensed User Longtime User Jun 4, 2007 #6 Thanks for all, finally this works well: (I tried to use compare operators like "<", ">", etc.) a = 118 posx="posx<"&a Table1.Filter(posx) Best regards
Thanks for all, finally this works well: (I tried to use compare operators like "<", ">", etc.) a = 118 posx="posx<"&a Table1.Filter(posx) Best regards