I have an application that performs the following SQL action:
UPDATE table SET value = date('now', ?1, 'localtime') WHERE id = ?2
In my code I bind an integer to ?1. This results in null. I never intended
to code it that way, it is an honest to goodness bug. I wanted to bind
'+1 days' or something similar. However, I wanted
to know if I could cheat.
Can a trigger reference the bound variables? I figure the answer is NO.
I realize exposing bound variables to a trigger is silly for many reasons,
but I figured I would ask the experts.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
