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,
> 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 ' ||
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
3 matches
Mail list logo