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
> [email protected]
> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
