I have been having an issue trying to resolve an error all afternoon, and hope that you might be able to help.
I am trying to execute the follow SQL "
SELECT m.name as tableName,
p.name as columnName
FROM sqlite_master m
left outer join pragma_table_info((m.name)) p
on m.name <> p.name
where columnName = 'UploadedFlag'
order by tableName, columnName
" That returns a list of the tables that Contain the 'UploadedFlag' Column. I have testing the SQL on both HeidiSQL and SQLite Expert Personal applications and run and return what I expect, however when I run it through LabVIEW I get a 402860 Error with the description " SQLITE_ERROR(1): near "(": syntax error "
If anyone could point me in the direction of the syntax error then I would be very greatful.
SQLite Error 402860
in Database and File IO
Posted
Good Afternoon,
I have been having an issue trying to resolve an error all afternoon, and hope that you might be able to help.
I am trying to execute the follow SQL "
SELECT m.name as tableName,
p.name as columnName
FROM sqlite_master m
left outer join pragma_table_info((m.name)) p
on m.name <> p.name
where columnName = 'UploadedFlag'
order by tableName, columnName
" That returns a list of the tables that Contain the 'UploadedFlag' Column. I have testing the SQL on both HeidiSQL and SQLite Expert Personal applications and run and return what I expect, however when I run it through LabVIEW I get a 402860 Error with the description " SQLITE_ERROR(1): near "(": syntax error "
If anyone could point me in the direction of the syntax error then I would be very greatful.
Regards
Mark