Re: [sqlite] Using Eclipse on Windows XP

Hi, what you need are first Eclipse, the C Development Tools (CDT) and a compiler for Example the MinGW Here are the links for the tools I used for my project. http://getamosaic.sourceforge.net/links.php regards, Tobias Alex Krzos schrieb: > Is there an easy way to develop on sqlite using

[sqlite] Building fts3 indexes on existing table

Hello, I'm just starting to explore sqlite, so apologies in advance for witlessness. I have imported a sizeable block of csv data into an sqlite3 table with this structure: CREATE TABLE mins (year NUMERIC, catno TEXT, name TEXT, country TEXT, locality TEXT, xlsystem TEXT, chemform TEXT, descrip

[sqlite] Question about concurrency

This question may sound a bit daft, but I'll ask anyway: If I use SQLite in the default SQLITE_CONFIG_SERIALIZED threading mode and share a connection among threads, does that connection support multiple simultaneous reads, or will each read access be serialized? I'm assuming that for maximum

Re: [sqlite] Getting the "position" (like LIMIT) for a query

Lukas Haase schrieb: > Igor Tandetnik schrieb: >> "Lukas Haase" wrote in >> message news:gkat07$n2...@ger.gmane.org >>> I use an SQLite database to fill a virtual list control in Windows. In >>> this control, I just tell the control the numer of my elements and the >>> control

Re: [sqlite] Using Eclipse on Windows XP

Alternatively you can install Dev-CPP IDE which automatically activates Mingw and compile Sqlite. schachtobi wrote: > Hi, > > what you need are first Eclipse, the C Development Tools (CDT) and a > compiler for Example the MinGW > > Here are the links for the tools I used for my project. > >

[sqlite] Stringcompare operator with COLLATE NOCASE

Hello, I have a table containting keywords: CREATE TABLE keywords( keywordID INTEGER PRIMARY KEY, keyword VARCHAR(100) ); INSERT INTO keywords VALUES(1,'Apple'); INSERT INTO keywords VALUES(2,'apple'); INSERT INTO keywords VALUES(3,'Angle'); INSERT INTO keywords VALUES(4,'Tree');

Re: [sqlite] Stringcompare operator with COLLATE NOCASE

"Lukas Haase" wrote in message news:gkd3f4$cl...@ger.gmane.org > This is not what I want. So I use COLLATE NOCASE: > > This is the result I want. However, now I need a WHERE clause to work > exactly the same. So I tried: > > SELECT keyword FROM keywords WHERE keyword < 'T*'

Re: [sqlite] Stringcompare operator with COLLATE NOCASE

Igor Tandetnik schrieb: > "Lukas Haase" wrote in > message news:gkd3f4$cl...@ger.gmane.org >> This is not what I want. So I use COLLATE NOCASE: >> >> This is the result I want. However, now I need a WHERE clause to work >> exactly the same. So I tried: >> >> SELECT keyword FROM

Re: [sqlite] How to create a Datatable [first steps of newbie]

It means that the connection that I use in the code that I showed you is the same as that used in other parts of the program, only that we do not work, I get that bug that I told you. Thanks for your availability. Roosevelt Anderson ha scritto: > What does your connection string look like? > >

Re: [sqlite] Getting the "position" (like LIMIT) for a query

On Sat, Jan 10, 2009 at 04:26:56PM -0600, Nicolas Williams wrote: > Incidentally, I think many, if not all queries that have an outer table > scan, and many, if not all joins that have an inner table scan but not > an outer table scan, could be programmatically modified to create a > scrolling

Re: [sqlite] How to create a Datatable [first steps of newbie]

http://sqlite.phxsoftware.com/forums/p/532/532.aspx On Sun, Jan 11, 2009 at 12:18 PM, Alessio Forconi wrote: > It means that the connection that I use in the code that I showed you is > the same as that used in other parts of the program, only that we do not > work, I get

Re: [sqlite] How to create a Datatable [first steps of newbie]

This is the connection string connString = String.Format("Data Source={0};New=False;Version=3", Properties.Settings.Default.DB_Path); and as I told you it works elsewhere in the program so the problem must be another one. Roosevelt Anderson ha scritto: >

Re: [sqlite] SPAM: Re: How to create a Datatable [first steps of newbie]

Since you're using a relative directory in your connection string (a filename with no path), make sure your Environment.CurrentDirectory is pointing to the right place at all times. For example, if you use an OpenFileDialog or SaveFileDialog, those classes change the CurrentDirectory. Once your

Re: [sqlite] Documentation to learn sqlite code for newbies?

It seems to me that you simply need something that will parse the csv file. You don't need SQLite unless you are going to import the data into a database. Bear in mind that a csv file is a database in its own right. All of the programming languages (Java, C, C++, C#) have libraries from which

Re: [sqlite] How to get the total row number of a table by Sqlite more efficient？

There is no guarantee that it always gets the correct result. For example, we insert 10 records and then delete 2 of them. If the 2 records does not hold the maximum id, the result is not correct. From: jesuscheung To:

[sqlite] trouble in creating table

I create a table in sqlite 3.5.9, return value indicates success but when I insert records into the table, the return error code is SQLITE_CORRUPT. I search internet web for answer,someone says the reason is there is no disk space left. But I am sure disk space is enough for database