I have lately began to make use of SQLite and started to integrate it right into a C# project I am focusing on.

However, at random my project will toss the exception:

Input array is more than the amount of posts within this table

I am getting a difficult time using the trace the issue since it appears to become tossed on the random basis.

DataTable table = new DataTable();

//exception is thrown here
table = Global.db.ExecuteQuery("SELECT * FROM vm_manager"); 

A few of the data that will get came back out of this totally the following:


If anybody has any advice, I'd be grateful.

EDIT: I am not able to exhibit the execute query work as it resides in the dll in the following sql lite wrapper http://www.codeproject.com/KB/database/cs_sqlitewrapper.aspx

EDIT 2 Problem comes from the brand new record array function inside this specific sql lite wrapper.

According to your SQLite wrapper's implementation, it's adding posts to the own internal DataTable before coming back to yours. I suspect your defect is incorporated in the wrapper, and never inside your code. I dug in to the supply of your SQLiteWrapper from CodeProject here you go at PasteBin: http://pastebin.com/AjGaX0kL

I suspect the mistake is happening for the reason that assistant method ExecuteQuery(), or its assistants: ReadFirstRow() or ReadFirstRow(), and never your code. Wrap your code inside a try catch. Inspect the Exception, and also the qualities will explain which method this exception is really being produced in.

Likely you are experiencing a defect within this wrapper class.

    DataTable table = Global.db.ExecuteQuery("SELECT * FROM vm_manager");
catch (Exception ex){
//who threw this from which method and line?

If the SQLite provider is not working, suggest evaluating: