Hey all,
i've an SQLite 3 database coming from a mobile phone (e2831) which
works well on the phone itself :
BEGIN TRANSACTION;
CREATE TABLE devicephonebook( UID INTEGER PRIMARY KEY
AUTOINCREMENT ,lastName TEXT NOT NULL DEFAULT(''),firstName TEXT
NOT NULL DEFAULT(''), lastChar INTEGER , fullLastName TEXT ,
ZYFLName TEXT , PYFLName TEXT , hasPhoto INTEGER DEFAULT(0) ,
timeStamp TEXT);
CREATE INDEX nameIndex ON devicephonebook (PYFLName, lastName,
firstName, lastChar, hasPhoto);
CREATE TRIGGER DELETE_EXT_TRIGGER AFTER DELETE ON devicephonebook
BEGIN DELETE FROM extraphonebook WHERE extraphonebook.UID =
OLD.UID; SELECT delete_from_cache(OLD.UID); END;
CREATE TRIGGER INSERT_PBK_TRIGGER AFTER INSERT ON devicephonebook
BEGIN UPDATE devicephonebook SET fullLastName=NEW.lastName||
NEW.firstName ,ZYFLName=get_zy_string(NEW.lastName||
NEW.firstName) ,PYFLName=get_py_string(NEW.lastName||
NEW.firstName) ,lastChar=get_first_char(NEW.lastName|| NEW.firstName)
WHERE UID=NEW.UID; END;
COMMIT;
if i want to insert a value like that :
INSERT INTO devicephonebook ( lastName, firstName ) VALUES( 'Smith',
'John' );
i get an error :
SQL logic error or missing database
Obviously i've implemented the custom functions get_zy_string,
get_py_string and get_first_char, those are returning the correct type.
if i insert all the needed values, such as :
INSERT INTO devicephonebook ( lastName, firstName, lastChar,
fullLastName, ZYFLName, PYFLName, hasPhoto, timeStamp ) VALUES
( 'Smith','John', 20, '', '', '', 0, 'dimanche' );
clearly, i don't understand this error.
in case you have some light...
best,
Yvon
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
