SQLite Views

[JFrost]

I have created a View in SQLite Studio for my SQ Lite database.  In that tool, I can query the table without issue.  I am using the SQLite Library v1.16.0.115 to interact with the database via LabVIEW.  When I use the LabVIEW toolkit and attempt to query the table, I receive error 402860 stating that the table (i.e. my View) does not exist. 

Query:  SELECT *
             FROM MyVIew
             LIMIT 1".

I am using the SQLite .dll version 3.51 on Windows 11.  Can LabVIEW be used with the SQLite Library to interact with database Views and if so, how?  

[drjdpowell · Accepted solution]

I use views all the time.  Are you sure you haven't created a Temporary view?

[johnooo1]

I developed the  project on notebook(win11,labview2020), I tested  query data, insert data and  delete data,all are fine;

I copy the project fold(include the same DB file) to another PC(win10,labview2020),Query data is fine ,but cannot insert data and delete data，report SQLITE_ERROR(1).

How to change the configuration of PC?

[JFrost]

@drjdpowell , I think that you were right.  I must have had a temporary table.  I created a new view again, and this time I was successful to accessing it via the SQLite library.  Thank you.