Re: [sqlite] Question about using SQLite3 on Windows Mobile 6+

Thank you sir! Indeed, I am writing it in .NET. Anthony - Original Message - From: "Roosevelt Anderson" To: "General Discussion of SQLite Database" Sent: Sunday, March 07, 2010 8:10 PM Subject: Re: [sqlite] Question about using

Re: [sqlite] Question about using SQLite3 on Windows Mobile 6+

I'm guessing you are writing this in .NET. If so, you need to use the sqlite ADO.NET provider found here: http://sqlite.phxsoftware.com/ On Sun, Mar 7, 2010 at 7:33 PM, Anthony Papillion wrote: > Hello Everyone, > > I'm totally new to SQLite and am trying to use it in a new

[sqlite] Question about using SQLite3 on Windows Mobile 6+

Hello Everyone, I'm totally new to SQLite and am trying to use it in a new Windows Mobile application. I've downloaded the SQLite3.dll and went to my project and tried to add a reference to the dll. For some reason, when I try to add the reference, I am told "A reference to sqlite3.dll could

Re: [sqlite] Feasability of a Range function

Jean-Christophe Deschamps wrote: >> Wouldn't it make more sense for "i in 1..5" to expand to "i >= 1 and i >> <= 5"? >> >> Then it would also work for ordered types that aren't ordinal, such as >> rationals >> and strings and blobs and dates etc, and it would work for very large >> ranges, >>

Re: [sqlite] Feasability of a Range function

>Wouldn't it make more sense for "i in 1..5" to expand to "i >= 1 and i ><= 5"? > >Then it would also work for ordered types that aren't ordinal, such as >rationals >and strings and blobs and dates etc, and it would work for very large >ranges, >since there's no conceptual need to generate all

[sqlite] SQLITE3 Recompiling for FTS3

For Windows: I followed the best of my ability recompiling the most current SQLITE3.DLL to get the FTS3 incorporated. I added the compiler directive SQLITE_ENABLE_FTS3 SQLITE_ENABLE_FTS3_PARENTHESIS and was able to create a SQLITE3.DLL but it faults when a example test C/C++ program runs. No

Re: [sqlite] Feasability of a Range function

Jean-Christophe Deschamps wrote: > I'm trying to determine if a Range(from, to) function can be made as an > extension function. > > Its effect would be to expand, for instance, range(1, 5) into (1, 2, 3, > 4, 5) for use in constructs similar to > select some_scalar_function(i) where

Re: [sqlite] how to execute an ATTACH DATABASE?

There is another condition I didn't see originally: You have to attach to the other database BEFORE starting the transaction. P.S. Who ever is responsible for putting in helpful error messages, God bless you! On Sun, Mar 7, 2010 at 4:34 PM, Sam Carleton wrote: > On

Re: [sqlite] Understanding TRANSACTION

I figured it out, I was NOT calling sqlite3_finalize(stmt) in the initial call to setDefaultIsInSlideShow() which was read only, so the table still had a read lock on it, so the read/write always failed. On Sun, Mar 7, 2010 at 3:36 PM, Sam Carleton wrote: > My use of

Re: [sqlite] Problem with SQLite in BCB 4

Well, sorry to hear that. I tested the function: vector CSGDb::query(char* query, sqlite3 *database) { sqlite3_stmt *statement; vector results; if(sqlite3_prepare_v2(database, query, -1, , 0) == SQLITE_OK) { int cols =

Re: [sqlite] how to execute an ATTACH DATABASE?

On Sun, Mar 7, 2010 at 4:16 PM, Jean-Christophe Deschamps wrote: > >>ATTACH DATABASE ?1 as sysDB > > AFAIK you can't use parameter binding for anything else than litteral > values. > > It makes sense since it would be impossible for the parser and > optimizer to evaluate and

Re: [sqlite] Problem with SQLite in BCB 4

Unfortunately it still doesn't work. I have error in line values.push_back(val); I tried to run program on Windows XP - I have this same error. Links to error screens: http://chimerian.net/error1.jpg http://chimerian.net/error2.jpg if(result == SQLITE_ROW)

Re: [sqlite] how to execute an ATTACH DATABASE?

>ATTACH DATABASE ?1 as sysDB AFAIK you can't use parameter binding for anything else than litteral values. It makes sense since it would be impossible for the parser and optimizer to evaluate and produce run-time code for a statement without knowing beforehand which database or column the

[sqlite] how to execute an ATTACH DATABASE?

I just posted a question a few minutes ago and it just dawned on me that the order I am calling things in that post is be ideal, so much that I would like to combine both web services calls. I want the transaction that enableSlideShow() creates to also execute the SQL which is called in

Re: [sqlite] Understanding TRANSACTION's

Please ignore this post, I just followed up with another post with a lot more info, I am still having the problem, though. Sam On Sun, Mar 7, 2010 at 10:27 AM, Sam Carleton wrote: > My use of SQLite is within a Apache module and Axis2/C web services.  At a > minimum,

[sqlite] Understanding TRANSACTION

My use of SQLite is within a Apache module and Axis2/C web services. Every request invokes a unique call to sqlite3_open_v2, most of the time there are multiple calls to sqlite3_open_v2 in one request. For example the module part, which sends configuration to the web servers calls sqlite3_open_v2

[sqlite] Understanding TRANSACTION's

My use of SQLite is within a Apache module and Axis2/C web services. At a minimum, every request invokes a unique call to sqlite3_open_v2, most of the time there are multiple calls to sqlite3_open_v2, one for each specific task. An example would be the module part, which sends configuration to

Re: [sqlite] Feasability of a Range function

>Ah. You want table-valued functions, like this: > >http://msdn.microsoft.com/en-us/library/ms191165.aspx Thanks Igor, that's what I had in mind. >In any case, SQLite doesn't support table-valued functions. The >closest thing to it is a virtual table: OK, got it, but this is a bit of heavy

Re: [sqlite] sqlite compile error

Gary Zigmann a écrit : Hello, Since sqlite is a library, could you show us your main program, in order to help you ? Best wishes Noël Frankinet > Good Afternoon, > > Today I downloaded sqlite-amalgamation-3_6_22.zip from the > sqlite.org website because I was looking for a SQL database to

Re: [sqlite] Feasability of a Range function

Jean-Christophe Deschamps wrote: >> Why not just >> >> select some_scalar_function(i) where i between 1 and 5; > > That's because we then get > No such column: i. Ah. You want table-valued functions, like this: http://msdn.microsoft.com/en-us/library/ms191165.aspx Those should appear where a

Re: [sqlite] Feasability of a Range function

>Why not just > >select some_scalar_function(i) where i between 1 and 5; That's because we then get No such column: i. That was not very important. I would have the use for such possibility but I can live without. My question was just curiosity about whether something along the line could

Re: [sqlite] Feasability of a Range function

Jean-Christophe Deschamps wrote: > I'm trying to determine if a Range(from, to) function can be made as an > extension function. > > Its effect would be to expand, for instance, range(1, 5) into (1, 2, 3, > 4, 5) for use in constructs similar to > select some_scalar_function(i) where i

[sqlite] Feasability of a Range function

I'm trying to determine if a Range(from, to) function can be made as an extension function. Its effect would be to expand, for instance, range(1, 5) into (1, 2, 3, 4, 5) for use in constructs similar to select some_scalar_function(i) where i in range(1, 5); without having to build a

Re: [sqlite] Crash after add column

- Original Message >From: VasiliyF4 >After I try to ADD a column by run the querry "ALTER TABLE x >ADD y NUMERIC" from my application, I can't use the data base any more. If I >try to get or save any data at my DB it cause crash of the application. Of course your

Re: [sqlite] Crash after add column

>I try to ADD a column by run the querry "ALTER TABLE x >ADD y NUMERIC" from my application, I can't use the data base any more. Try this: "ALTER TABLE main.x ADD y NUMERIC" and verify by external tool that column x has been added.

[sqlite] Running SQlite commands from perl 5.8.0

Hi, Have anyone managed to automate SQLite commands via perl 5.8.0? I've tried to install the DBD::SQLite module but it is supportd from 5.8.1 only. If any of you have any idea, I'd appreciate it. YG "This e-mail message may contain confidential, commercial or

Re: [sqlite] Crash after add column

On Sat, 2010-03-06 at 23:39 -0800, VasiliyF4 wrote: > I Use C/Linux. After I try to ADD a column by run the querry "ALTER TABLE x > ADD y NUMERIC" from my application, I can't use the data base any more. If I > try to get or save any data at my DB it cause crash of the application. Could you