Gianni M Well-Known Member Licensed User Longtime User Nov 15, 2022 #1 Hi, i have a B4XTable and fill it (all ok!) now i type into "Search Field" - example "cherokee" - and B4XTable work very well in upper left i see "1 to 35 (more available)" now, how to detect which are 35 records selected after "search" maybe i have to manage sub Code: Copy Sub B4XTable1_DataUpdated
Hi, i have a B4XTable and fill it (all ok!) now i type into "Search Field" - example "cherokee" - and B4XTable work very well in upper left i see "1 to 35 (more available)" now, how to detect which are 35 records selected after "search" maybe i have to manage sub Code: Copy Sub B4XTable1_DataUpdated
Gianni M Well-Known Member Licensed User Longtime User Nov 15, 2022 #2 solved Code: Copy Sub B4XTable1_DataUpdated Dim o() As Object = B4XTable1.BuildQuery(False) 'True to include the page LIMIT in the query. Dim rs As ResultSet = B4XTable1.sql1.ExecQuery2(o(0), o(1)) End Sub Upvote 0
solved Code: Copy Sub B4XTable1_DataUpdated Dim o() As Object = B4XTable1.BuildQuery(False) 'True to include the page LIMIT in the query. Dim rs As ResultSet = B4XTable1.sql1.ExecQuery2(o(0), o(1)) End Sub