dimsuz
05/27/2019, 5:58 PMCREATE VIEW series_full AS
SELECT series.id, series.name
FROM series
JOIN series_category ON series_category.id = series.id
ORDER BY rowid ASC;
find_one_by_id:
SELECT *
FROM series_full
WHERE id = ?;
I get an exception:
SQLiteException: no such table: series_full (code 1): , while compiling: SELECT * FROM series_full WHERE id = ?1
dimsuz
05/27/2019, 6:00 PMdimsuz
05/27/2019, 6:02 PMyshrsmz
05/28/2019, 6:39 AMyshrsmz
05/28/2019, 10:53 AMyshrsmz
05/28/2019, 10:53 AMdimsuz
05/28/2019, 12:53 PMyshrsmz
05/28/2019, 1:52 PMdimsuz
05/29/2019, 7:37 PMalec
05/29/2019, 7:43 PMlinked.linked_id
to linked.linked_id AS linked_id
in the view's select work?dimsuz
05/29/2019, 7:57 PMalec
05/29/2019, 7:59 PM