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

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 ' || u.Username
> ),
> 'ZZzxzzxczxde', 'TEST SUBJECT')
>
>   

Try it this way:

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


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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