Re: [sqlite] Variables in Triggers

[Igor Tandetnik]

"David Moorhouse" 
wrote in message news:vue6q453ln9isiut2m808u76qecq9ao...@4ax.com
> I'd like to have a condition in a trigger that examines a variable
> (set outside the trigger) and acts accordingly.
>
> Are there any SET style statements for environmental variables in
> SQLite ?

Create a one-row-one-column table, put the value there, query the table 
in the trigger. If you have multiple variables, you can perhaps have a 
two-column table storing name/value pairs.

Igor Tandetnik 



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Variables in Triggers

[David Moorhouse]

I'd like to have a condition in a trigger that examines a variable (set
outside the trigger) and acts accordingly.

Are there any SET style statements for environmental variables in SQLite ?

Thanks

D

-
David Moorhouse
Development Director
Moorhouse Works ltd
phone 027 236 5415
www.moorhouse.co.nz
-

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users