Clemens Ladisch wrote...
On 07/26/2014 06:22 AM, jose isaias cabrera wrote:
INSERT OR REPLACE INTO LSOpenProjects
SELECT * FROM client.LSOpenProjects WHERE id = 1 AND Date !=
A.Date;
What is A?
Sorry, this should have been written like this.
INSERT OR REPLACE INTO
On 07/27/2014 12:11 PM, com...@gmx.ch wrote:
> when enabling foreign_keys via
> PRAGMA foreign_keys=ON;
> multi row inserts fail when having a foreign key and adding a value as
> well as the reference in a transaction fails as well.
Normally, foreign key constraints are checked as soon as each
On 27 Jul 2014, at 11:11am, com...@gmx.ch wrote:
> Example is attached.
We apologise, but it's intentionally difficult to attach files to posts to this
list. If your text is short, could you just paste it into a post ? If it's
long, can you put it on a server and post a pointer to it ?
Hi all,
I logged this bug via Gentoo, but it should be done here...
https://bugs.gentoo.org/show_bug.cgi?id=517110
"
This function is wrapped up inside SQLITE_OMIT_WAL, whereas it's needed
elsewhere. This function needs to be moved out of this ifdef.
/*
** Return the system page size.
**
**
Hi,
when enabling foreign_keys via
PRAGMA foreign_keys=ON;
multi row inserts fail when having a foreign key and adding a value as
well as the reference in a transaction fails as well.
Example is attached.
Fails for me on
SQLite 3.8.2 2013-12-06 14:53:30
On 2014/07/27 12:07, michael walsley wrote:
Why doesn't AUTOINCREMENT work like rowid, in that, with rowid if the value
on insert is not null it doesn't get a new rowid, it just accepts the value
as in the insert?
Im trying to develop a win phone app in that data downloaded from the
On 07/26/2014 06:22 AM, jose isaias cabrera wrote:
>INSERT OR REPLACE INTO LSOpenProjects
> SELECT * FROM client.LSOpenProjects WHERE id = 1 AND Date !=
> A.Date;
What is A?
Regards,
Clemens
___
sqlite-users mailing list
On 07/27/2014 12:07 PM, michael walsley wrote:
> Why doesn't AUTOINCREMENT work like rowid, in that, with rowid if the value
> on insert is not null it doesn't get a new rowid, it just accepts the value
> as in the insert?
sqlite> create table t(x integer primary key autoincrement);
sqlite>
Why doesn't AUTOINCREMENT work like rowid, in that, with rowid if the value
on insert is not null it doesn't get a new rowid, it just accepts the value
as in the insert?
Im trying to develop a win phone app in that data downloaded from the server
needs to insert as it comes, but rows added on
9 matches
Mail list logo