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')
Get "near "(": syntax error."
As soon as I change the nested query to a fixed scalar value, this INSERT
statement starts working. I'm 100% sure that the nested query returns scalar
value. What's wrong to my SQL and how to fix it?
--
View this message in context:
http://old.nabble.com/What%27s-the-problem-with-my-INSERT-clause--tp27730855p27730855.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
