0000075: change template for create trigger on views!

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0000075

[sqliteman] SQL engine

major

always

2008-01-17 07:18

2008-03-21 09:03

Reporter

wiaz

View Status

public

Assigned To

subzero

Priority

normal

Resolution

fixed

Status

closed

Product Version

1.1svn

Summary

0000075: change template for create trigger on views!

Description

now you have both the same, for tables and views but for views
it should be rather like this:

-- sqlite3 simple trigger template
CREATE TRIGGER [IF NOT EXISTS] "<trigger_name>"
INSTEAD OF [DELETE | INSERT | UPDATE | UPDATE OF <column-list>]
ON [database-name .] view-name
[ FOR EACH ROW | FOR EACH STATEMENT ] [ WHEN expression ]
BEGIN
<select * from foo;>
END;

Additional Information

Tags

No tags attached.

Attached Files

Relationships

There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2008-01-17 07:18	wiaz	New Issue
2008-01-17 13:10	subzero	Status	new => resolved
2008-01-17 13:10	subzero	Fixed in Version	=> 1.1svn
2008-01-17 13:10	subzero	Resolution	open => fixed
2008-01-17 13:10	subzero	Assigned To	=> subzero
2008-03-21 09:03	subzero	Status	resolved => closed

Mantis 1.1.7[^]