J JamesC Member Licensed User Jul 20, 2008 #1 It's quite straightforward to create a table from the first 500 results of a query, with cmd.ExecuteTable("table1",500). Is there a simple way to create a table from the second 500 results of the query, i.e. records 500-999? Thanks James
It's quite straightforward to create a table from the first 500 results of a query, with cmd.ExecuteTable("table1",500). Is there a simple way to create a table from the second 500 results of the query, i.e. records 500-999? Thanks James
Erel B4X founder Staff member Licensed User Longtime User Jul 20, 2008 #2 You should add LIMIT and OFFSET to your query: B4X: cmd.CommandText = "SELECT * FROM table WHERE... ORDER BY... LIMIT 500 OFFSET 500" cmd.ExecuteTable("table1",0) See this page for more information: SQLite Query Language: SELECT
You should add LIMIT and OFFSET to your query: B4X: cmd.CommandText = "SELECT * FROM table WHERE... ORDER BY... LIMIT 500 OFFSET 500" cmd.ExecuteTable("table1",0) See this page for more information: SQLite Query Language: SELECT