Re: [sqlite] Duplicated primary key error

Mariano Martinez Peck wrote: > > 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 IN

Re: [sqlite] Duplicated primary key error

Sorry for my English. I cannot express well my problem. The thing is: I know how primary key works, but I don't understand the error I am getting from sqlite3. I mean, If I tried to execute a query which is an insert with an existing pk, is it ok to receive BUSY or IOERR_BLOCKED ? That is what I

Re: [sqlite] Duplicated primary key error

On 9/28/08, Mariano Martinez Peck <[EMAIL PROTECTED]> wrote: > 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? Yes. The PR

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

[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