sql - WebSQL create view -

sql - WebSQL create view -

is possible utilize views websql? assume because sqlite allows it, might wrong. trying create view in local sqlite database fails no matter do. here of things i've tried far;

create view my_view select id, name my_table active = 1; --fails: not prepare statement (1 no such table: main.my_table)

why search table 'my_table' in 'main' database? not aware of 'main' database. assume scheme database there default. database open labeled 'my_database'. other sql statements seem respect that. 'create view' 1 looks operates outside of opened database.

create view my_view select id, name my_database.my_table active = 1; --fails: not prepare statement (1 view my_view cannot reference objects in database my_database)

this makes me believe 'create view' statement operates outside of opened database.

create view my_database.my_view select id, name my_database.my_table active = 1; --fails: not prepare statement (1 unknown database my_database)

this 1 confuses me most. how can there 'my_database' database unknown? can assure using database quite bunch of other statements such select, insert, update, delete , of them work fine. 'create view' database unknown.

create view my_database.my_view select id, name my_table active = 1; --fails: not prepare statement (1 unknown database my_database)

i tried run these 1 @ time before 'create view':

attach 'my_database.db' my_database; --fails: not prepare statement (23 not authorized) attach 'my_database.sqlite' my_database; --fails: not prepare statement (23 not authorized)

any help appreciated. thanks.

the default database (the database opened) called main.

you error "no such table: main.my_table" because database not contain table called my_table.

sql database sqlite views web-sql