tbl definition
CREATE TABLE [TB_User] (
[ObjectID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[UserName] VARCHAR(30) UNIQUE NOT NULL,
[IsActive] bit DEFAULT '1' NULL
);
trigger definition:
CREATE TRIGGER [ON_TBL_TB_USER_INSERT_ADD_DEFAULT_CALENDAR]
AFTER INSERT ON [TB_User]
FOR EACH ROW
BEGIN
insert into TB_GroupCalendar(CalendarName) VALUES('DEFAULT CALENDAR FOR '
+ UserName) ;
insert into TB_User_GroupCalendar(UserID,GroupCalendarID) VALUES(ObjectID,
last_insert_rowid() ) ;
END;
When I try to execute this:
insert into [TB_User](UserName) values('QQQQQQQQQQ')
I get error " no such column: UserName ". Why? And how to write it
correctly?
--
View this message in context:
http://old.nabble.com/no-such-column%3A-UserName---Why--tp27724824p27724824.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
