Am 10.06.12 14:59, schrieb Petite Abeille:
>
> The short of it is that you can't. SQLite doesn't support such constraints.
> Only the basics are supported: primary, unique, referential, not null, check:
>
Thank you for that information. It saves me a lot of time searching for
a solution that do
Am 10.06.12 14:49, schrieb Guenther Boelter:
> On 06/10/2012 08:35 PM, Wolfgang Meiners wrote:
>> So my question is: (how) can i write an integrity constraint in sqlite3
>> (version 3.6.12) which is equivalent to the part
>> SELECT CASE
>>
Hello,
i have written a sqlite3-db for a small books library. Within this db
there is a table:
sqlite> .schema ausleihen
CREATE TABLE ausleihen (
aid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
pid INTEGER NOT NULL,
beid INTEGER NOT NULL,
ausleihdatum DATE NOT NULL,
Am 04.06.12 19:36, schrieb Igor Tandetnik:
>
> http://sqlite.org/lang.html
> http://sqlite.org/syntaxdiagrams.html
>
I just found the case expression. I did not know it before. Thank you
for pointing me to that direction!
Wolfgang
___
sqlite-users mail
Am 04.06.12 19:31, schrieb Michael Schlenker:
> Am 04.06.2012 19:25, schrieb Wolfgang Meiners:
>> Am 04.06.12 18:59, schrieb Igor Tandetnik:
>>> On 6/4/2012 12:33 PM, Wolfgang Meiners wrote:
>>>> this trigger does work but i think it is not in accordance with the
>
Am 04.06.12 18:59, schrieb Igor Tandetnik:
> On 6/4/2012 12:33 PM, Wolfgang Meiners wrote:
>> this trigger does work but i think it is not in accordance with the
>> syntax diagram of TRIGGER on
>> http://sqlite.com/lang_createtrigger.html
>
> Which part do you feel is
Hi,
I have written the following trigger with ideas from stackoverflow:
(OSX 10.6.8, SQLite 3.6.12)
This is for a book library. If i delete a bookexemplar from the library,
this should not be possible if this bookexemplar is on loan, which means
ausleihen.rueckgabe IS NULL. Otherwise every infor
7 matches
Mail list logo