senglory <sengl...@gmail.com> wrote:
> 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) ;
What does UserName refer to here? If you want to use the value from the
just-inserted row, that would be new.UserName
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
