Hello Tobi,
i did not mean to say rtfm, but wanted to add my own question.
Thanks for answering it.
Martin
schachtobi wrote:
> Hello Martin,
>
> wow 7 Minutes to scan the manual. Yes I know RTFM :o
>
> The update trigger is not issued if this test is correct here:
>
> sqlite> create trigger fku before update on ch for each row begin
> delete from blobdata where chId=old.id; end;
> sqlite> select fname from ch limit 1;
> 100_5763.JPG.JPG
> sqlite> select * from ch limit 1;
> 1|100_5763.JPG.JPG|137|118|127|512
> sqlite> insert or replace into ch(fname, red, green, blue, dsize)
> values ('xxx', 0, 0, 0, 0);
> sqlite> select chId from blobdata where chId = 1;
> 1
>
> The entry is still here.
>
> Tobias
>
>
> Martin Engelschalk schrieb:
>
>> Hello Tobi,
>>
>> See http://www.sqlite.org/lang_conflict.html, near the bottom:
>>
>> "When this conflict resolution strategy deletes rows in order to satisfy
>> a constraint, it does not invoke delete triggers on those rows. This
>> behavior might change in a future release."
>>
>> I would be interested if an UPDATE - Trigger is invoked instead. Perhaps
>> you could try it?
>>
>> Martin
>>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
