subject:"\[sqlite\] What's the problem with my INSERT clause\?"

Re: [sqlite] What's the problem with my INSERT clause?

2010-02-27 Thread senglory

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,

Re: [sqlite] What's the problem with my INSERT clause?

2010-02-27 Thread Mark Brand

> 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 ' ||

Re: [sqlite] What's the problem with my INSERT clause?

2010-02-27 Thread Igor Tandetnik

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

[sqlite] What's the problem with my INSERT clause?

2010-02-27 Thread senglory

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 ),