F faustinofaria New Member Licensed User Longtime User Mar 24, 2008 #1 Hello Friends. My table have 1500 lines and 4 columns. How to search a line in a table with more speed? I'm using: For i=0 to tbTable.RowCount-1 If tbTable.Cell( "MyKey" , i ) = sKey Then ...... My Code.... End If Next But it is too much slow. Can you help me, please? Thanks. Sorry my poor english. I'm a Brazilian user.
Hello Friends. My table have 1500 lines and 4 columns. How to search a line in a table with more speed? I'm using: For i=0 to tbTable.RowCount-1 If tbTable.Cell( "MyKey" , i ) = sKey Then ...... My Code.... End If Next But it is too much slow. Can you help me, please? Thanks. Sorry my poor english. I'm a Brazilian user.
Erel B4X founder Staff member Licensed User Longtime User Mar 24, 2008 #2 You should use the Filter method: B4X: tbTable.Filter("MyKey = '" & sKey & "'") For i=0 to tbTable.RowCount-1 If tbTable.Cell( "MyKey" , i ) = sKey Then ...... My Code.... End If Next
You should use the Filter method: B4X: tbTable.Filter("MyKey = '" & sKey & "'") For i=0 to tbTable.RowCount-1 If tbTable.Cell( "MyKey" , i ) = sKey Then ...... My Code.... End If Next