Re: [sqlite] accessing bound variables in trigger

Rich Rattanni wrote: > Can a trigger reference the bound variables? I figure the answer is > NO. The answer is NO. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] accessing bound variables in trigger

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