Re: [sqlite] insert or replace

Do you have a primary key on the table you're running the insert or replace statement on? I'm assuming you meant the record already exists. SB On Thu, Jan 8, 2009 at 9:30 AM, liron.levy10 wrote: > > i am trying to use the "insert or replace" query command , and "insert" is > the command who ex

Re: [sqlite] Creating sqlite.dll and sqliteclient.dll for .net with sqlite version 3-3.6.7

Trien, You might want to check this out: http://sqlite.phxsoftware.com/ I use it, and it works well for my needs. SB On Mon, Jan 5, 2009 at 5:39 PM, Dao, Trien (STP) wrote: > I am new to sqlite development community. I need to create or obtain > sqlite.dll and sqliteclient.dll for sqlite ve

Re: [sqlite] Quick question:

Jason, Chances are you will have to compile it for CE. I imagine it uses a different compiler/SDK than standard XP. Use the amalgamated version of the source - it's very easy. SB On Mon, Jan 5, 2009 at 1:28 PM, jason young wrote: > Quick question: > Can anyone tell me what is involved with g

Re: [sqlite] sqlite and threads

.Say you have an error in one thread where a > transaction was started. The next thread that creates a connection will > perform error recovery on the database. And you process/app would continue > normally. > > > HTH > > > > > --- On Mon, 1/5/09, S B wrote: >

[sqlite] sqlite and threads

Hello, From: http://www.sqlite.org/faq.html#q6 "The restriction on moving database connections across threads was relaxed somewhat in version 3.3.1 . With that and subsequent versions, it is safe to move a connection handle across threads as long as th