Re: [sqlite] Duplicated primary key error

EY must be > unique > > > > Any ideas? > > Yes. The PRIMARY KEY must be unique. In other words, it should not be > a duplicate of one that already exists. That is the whole idea behind > a PRIMARY KEY. Which part of that is causing confusion? > > > > > man

Re: [sqlite] Duplicated primary key error

Please I need help with this :( I am getting BUSY or IOERR_BLOCKED when inserting a duplicated pk through C interface. If I do it through sqlite.exe I get: SQL error: PRIMARY KEY must be unique Any ideas? many thanks, mariano On Sun, Sep 21, 2008 at 9:05 PM, Mariano Martinez Peck < [EM

Re: [sqlite] How to download a old sqlite version?

thanks, mariano On Wed, Sep 24, 2008 at 10:15 PM, Mariano Martinez Peck < [EMAIL PROTECTED]> wrote: > Sorry, I forgot to said I already tried > http://www.sqlite.org/sqlite-3_4_2.zip and I got this: > Document Not Found The document /sqlite-3_4_2.zip is not avaivable on this > s

Re: [sqlite] How to download a old sqlite version?

Sorry, I forgot to said I already tried http://www.sqlite.org/sqlite-3_4_2.zip and I got this: Document Not Found The document /sqlite-3_4_2.zip is not avaivable on this server cheers, mariano On Wed, Sep 24, 2008 at 9:51 PM, Mariano Martinez Peck < [EMAIL PROTECTED]> wrote: > H

[sqlite] How to download a old sqlite version?

Hi! I need to download sqlite (exe), dll and source code of sqlite 3.4.2 but I don't find it. Does someone know where to get it ? I CANNOT USE LAST SQLITE VERSION!!! I need 3.4.2 many thanks, Mariano ___ sqlite-users mailing list sqlite-users@sqlite.or

[sqlite] Duplicated primary key error

Hi everybody! This is my first post in this list! I am very newbie with Sqlite. This is the first time I am trying to use it. I am using Sqlite3 trough C interface. The problem I have is this: I have a table created, just like this: CREATE TABLE materia( codigo INTEGER PRIMARY KEY, nombre