1. Black Friday Sale - 50% off

    B4A Standard for $29 instead of $59!
    Buy Now
    Dismiss Notice

SQLite ExecuteTable

Discussion in 'Questions (Windows Mobile)' started by JamesC, Jul 20, 2008.

  1. JamesC

    JamesC Member Licensed User

    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
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    You should add LIMIT and OFFSET to your query:
    Code:
    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
     
  3. JamesC

    JamesC Member Licensed User

    Ta

    Thanks, Erel - that's just what I needed!
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice