SQLite ExecuteTable

JamesC · #1 (**permalink**) 07-20-2008, 04:34 AM

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 · #2 (**permalink**) 07-20-2008, 06:04 AM

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

JamesC · #3 (**permalink**) 07-20-2008, 11:21 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error with ExecuteTable	N1c0_ds	Questions & Help Needed	1	10-22-2008 12:49 AM
cmd.ExecuteTable("table1",500) error	dennishea	Questions & Help Needed	3	06-15-2008 04:17 PM
SQL - ExecuteTable - change colname	michael2007	Questions & Help Needed	2	04-17-2008 07:30 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)