On 30 May 2015, at 7:07pm, Etienne Charland <mysteryx93 at hotmail.com> wrote: > > As an update, replacing Guid with String in the database and code worked. I > got everything to work except the "parser stack overflow" error. The > application is much snappier than when running with a SQL Server LocalDB > database.
According to <http://www.sqlite.org/limits.html#max_expr_depth> the default maximum depth of a parse tree is 1000. Is it possible that you're using a copy of SQLite with a different SQLITE_MAX_EXPR_DEPTH, possibly set like that to reduce the amount of memory SQLite can use ? The alternative is that the parser concerned is not the one in SQLite but the one in the language you're using. But if your code worked with another SQL engine this can't be true. I don't understand the original SELECT you posted, where values seem to be passed along from one project to another, apparently without any need to ever stop. I'm concerned that if we solve the problem for the 27 projects you're currently using you're just going to add another 10 or 20 projects until the problem occurs again. Isn't there some way to archive off old projects and work only within your current project ? Simon.
