Thanks a lot. That was the problem. Igor Tandetnik wrote: > > Sara1409 wrote: >> It is clear that those variables (new.contactnom, new.contactage, >> new.contactmobile, new.contactmail, new.contactadresse) are token as >> String, I tried many combinations (' + new.contactnom +', ' " +" >> new.contactnom "+"',:) to resolve this problem but I failed ! > > In SQL, string concatenation opeartor is || (two vertical bars). > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >
-- View this message in context: http://www.nabble.com/get-query-from-sqlite-database-with-triggers-tp25434506p25434941.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users