SQLite ExecuteTable

[JamesC]

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]

You should add LIMIT and OFFSET to your query:

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

 

[JamesC]

Ta

Thanks, Erel - that's just what I needed!