Re: Re[2]: [sqlite] Regarding aborting a query

2006-10-03 Thread He Shiming
Actually it implements such syntax. See LIMIT and OFFSET at http://www.sqlite.org/lang_select.html Filip Right, I missed that. Sorry for the confusion. Best regards, He Shiming - To unsubscribe, send email to

Re[2]: [sqlite] Regarding aborting a query

2006-10-03 Thread Filip Navara
> At the present time, sqlite hadn't implemented syntax such as LIMIT 0,5. So > you have to do it manually. It's fairly easy if you use prepared statements. > The steps are as follows: Actually it implements such syntax. See LIMIT and OFFSET at http://www.sqlite.org/lang_select.html Filip

Re: [sqlite] Regarding aborting a query

2006-10-03 Thread He Shiming
Hi List, Let us assume there are 10 results for a Query. If I want to abort the Query after 5 results How can I do that? What notification I will get once I got all the results and of if there are any errors after 6th result. How to specify a primary Key, foreign key while creating a table.

[sqlite] Regarding aborting a query

2006-10-03 Thread Vivek R
Hi List, Let us assume there are 10 results for a Query. If I want to abort the Query after 5 results How can I do that? What notification I will get once I got all the results and of if there are any errors after 6th result. How to specify a primary Key, foreign key while creating a table.