[sqlite] INSERT OR REPLACE in a virtual table implementation....

2014-10-17 Thread dave
I have a virtual table implementation, and I would like to use the INSERT OR REPLACE syntax to simplify actions for the user. In my xUpdate method, for the case where insertion is occuring, else if ( argc 1 SQLITE_NULL == sqlite3_value_type ( argv[0] ) ) { I do check a uniqueness constraint,

Re: [sqlite] INSERT OR REPLACE in a virtual table implementation....

2014-10-17 Thread Dan Kennedy
On 10/18/2014 01:07 AM, dave wrote: I have a virtual table implementation, and I would like to use the INSERT OR REPLACE syntax to simplify actions for the user. In my xUpdate method, for the case where insertion is occuring, else if ( argc 1 SQLITE_NULL == sqlite3_value_type ( argv[0] ) ) {

Re: [sqlite] INSERT OR REPLACE in a virtual table implementation....

2014-10-17 Thread dave
... On 10/18/2014 01:07 AM, dave wrote: I have a virtual table implementation, and I would like to use the INSERT OR REPLACE syntax to simplify actions for the user. In my xUpdate method, for the case where insertion is occuring, ... on a virtual table, or something else, or maybe