[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.

Re: [sqlite] How to create DLL for windows?

2006-10-03 Thread Miha Vrhovnik
Why don't you use mingw + msys enviroment? Google for more. Regards, Miha Yuvaraj Athur Raghuvir [EMAIL PROTECTED] je ob 3.10.2006 3:19:21 napisal(a): Hello, I have sync'ed and created the exe using Cygwin on Windows. I also have the libtool available. Now, I donot see the dll that I can use

Re: [sqlite] Regarding Performance and removing create view

2006-10-03 Thread He Shiming
Hi List, we have ported SQLite to one of our consumer products. We require some minimal applications only like creating and deleting table and Inserting , Querying, deleting rows in a table. So, We are planning to remove some of the features like create view and etc , as we are facing some

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] Installing Library

2006-10-03 Thread Lloyd
Hi All, I have downloaded the SQLite library (sqlite-3.3.7.so.gz) from the homepage. But I don't know how to install it. Please help me. My Redhat Enterprise Linux machine runs on i386 architecture. Thanks and Regards, Lloyd. __ Scanned and protected by

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: 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: [sqlite] Problem with close

2006-10-03 Thread Onnig Kouyoumdjian
Thanks. I will give that a try. -Original Message- From: Roger Binns [mailto:[EMAIL PROTECTED] Sent: Friday, September 29, 2006 6:23 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Problem with close Onnig Kouyoumdjian wrote: One reason is that with the Finisar, I can specify

[sqlite] Re: How to find errors ?

2006-10-03 Thread Martin Alfredsson
Martin Alfredsson ma1999 at jma.se wrote: I understand, I to did not understand what happened. But the code below shows my point (sorry for the horrible indentation). Rather than apologize, why not just fix it? Is your time so much more valuable than ours that you cannot be troubled with such