SQLite – could not prepare statement (1 too many SQL variables)

During development for SQLite, I have got this error

could not prepare statement (1 too many SQL variables)

Accroding to this article, this error is because of SQLite limitation, which cannot put variables more than 999 variables.

After I reduce the amount of variables, it worked very well.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.