T ToolboxZX Member Licensed User Longtime User Mar 17, 2017 #1 Is there a method or way to obtain the number of rows loaded in an ABMTable?
Harris Expert Licensed User Longtime User Mar 17, 2017 #2 Count the results returned from the query used to populate the table. Code: SQL_cnt = "SELECT CaseID from cmeeting Where mastid = "& mst_id & " AND comp_id = "&Main.comp_id Dim count_cases As List = DBM.SQLSelect(SQL, SQL_cnt, Null) Dim Number_of_Records as Int = count_cases.size ' total number of records returned.... Upvote 0
Count the results returned from the query used to populate the table. Code: SQL_cnt = "SELECT CaseID from cmeeting Where mastid = "& mst_id & " AND comp_id = "&Main.comp_id Dim count_cases As List = DBM.SQLSelect(SQL, SQL_cnt, Null) Dim Number_of_Records as Int = count_cases.size ' total number of records returned....
T ToolboxZX Member Licensed User Longtime User Mar 17, 2017 #3 Yes, I ended up resorting to a method similar to that. In my case the table isn't built from a single query, so I just ended up using a variable to keep track of the number of rows added as they were incurred. That counter is then used elsewhere without having to replicate the process that populates the table. I was just curious if there was a method, property or object that exposes the row count of the table object. Thank you for the example though Upvote 0
Yes, I ended up resorting to a method similar to that. In my case the table isn't built from a single query, so I just ended up using a variable to keep track of the number of rows added as they were incurred. That counter is then used elsewhere without having to replicate the process that populates the table. I was just curious if there was a method, property or object that exposes the row count of the table object. Thank you for the example though
