Trying to update a table view using: 

CREATE OR REPLACE VIEW [vtable] AS SELECT * FROM Files_Table ORDER BY File

The table is returning the old view, not the updated.

Statement tested in the Sqlite database browser: 

Error message from database engine: near "OR": syntax error

but didn't get this in the program?

Any idea why it's not updating?

sql database sqlite database-design
Edit
Report