"David Moorhouse" <[email protected]> wrote in message news:[email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
