Oops, my INSERT started working as soon as I removed some lines before it in SQLIte Expert. And you solution works as well. Thanks.
BTW, can you recommend me suitable UI to work with SQLite? Igor Tandetnik wrote: > > senglory wrote: >> insert into tb_appointment(GroupCalendarID, ObjectID, Subject) values( >> ( >> select ugc.GroupCalendarID >> from TB_User_GroupCalendar ugc >> join TB_User u on u.objectID = ugc.UserID >> join TB_GroupCalendar gc on gc.ObjectID = ugc.GroupCalendarID >> where calendarname='DEFAULT CALENDAR FOR ' || u.Username >> ), >> 'ZZzxzzxczxde', 'TEST SUBJECT') > > insert into tb_appointment(GroupCalendarID, ObjectID, Subject) > select ugc.GroupCalendarID, 'ZZzxzzxczxde', 'TEST SUBJECT' > from TB_User_GroupCalendar ugc > join TB_User u on u.objectID = ugc.UserID > join TB_GroupCalendar gc on gc.ObjectID = ugc.GroupCalendarID > where calendarname='DEFAULT CALENDAR FOR ' || u.Username; > > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/What%27s-the-problem-with-my-INSERT-clause--tp27730855p27730974.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
