Mihai Limbasan wrote:
> In your example it wasn't.
Oops, misread what you wrote.
What I mean is that it doesn't matter whether the ID is autogenerated or
not (of
course, if it isn't then the whole issue becomes moot - it in fact
*should* be PRIMARY KEY AUTOINCREMENT.)
___
Igor Tandetnik wrote:
>> Sure. I'll use your examples, just making sure to add an id insertion
>> in the first statement since the id column isn't specified as
>> autoincrement.
>>
>
> But it _is_ specified as INTEGER PRIMARY KEY.
In your example it wasn't. It also wasn't in Martin's original
Mihai Limbasan <[EMAIL PROTECTED]> wrote:
> Igor Tandetnik wrote:
>> Can you show an example of a trigger that would make these statements
>> work:
>>
>> insert into snapshot (bumf) values ('one');
>> insert into sample(type, used) values ('a', 1);
>> insert into sample(type, used) values ('b', 1);
Igor Tandetnik wrote:
> Can you show an example of a trigger that would make these statements
> work:
>
> insert into snapshot (bumf) values ('one');
> insert into sample(type, used) values ('a', 1);
> insert into sample(type, used) values ('b', 1);
>
> so that, at the end, the two new records in
Mihai Limbasan <[EMAIL PROTECTED]> wrote:
>> Igor Tandetnik wrote:
>>> You can't make this happen automatically with SQLite.
>
>> Hmm? Of course you can. Just use a trigger:
>> http://sqlite.org/lang_createtrigger.html
Can you show an example of a trigger that would make these statements
work:
i
Igor Tandetnik wrote:
You can't make this happen automatically with SQLite.
Hmm? Of course you can. Just use a trigger:
http://sqlite.org/lang_createtrigger.html
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailm
"martin linklater"
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi. I'm real new to SQLite via the command line, but I have used
> CoreData quite a bit on OSX. My problem is that I have two tables
> that I want to link via a unique ID, but I don' t know how to
> automatically link
Hi. I'm real new to SQLite via the command line, but I have used CoreData
quite a bit on OSX. My problem is that I have two tables that I want to link
via a unique ID, but I don' t know how to automatically link the ID
parameter properly. My tables look like this:
create table snapshot( id INTEGER
8 matches
Mail list logo
