On 10 Mar 2016, at 4:43am, Marv Anderson <marva at pobox.com> wrote:
> SQL Logic error or missing database near "SELECT": syntax error > > SELECT CONVERT(Int,SCOPE_IDENTITY()) AS [value] This involves two things which are not built into SQLite: CONVERT() SCOPE_IDENTITY() Assuming that they're provided by your development environment that's fine. Unfortunately, the SQLite interface you're using ignored the detailed error message produced by SQLite, which would tell you where the syntax error was, and instead is just giving you a generic error message. I suspect you should talk to people who know about the SQLite Linq package to get a better understanding of the fault. Simon.
