search

vijirams / csharp-sqlite

Automatically exported from code.google.com/p/csharp-sqlite
Other
0 stars 0 forks source link

ExecuteQuery not working #24

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?

        SQLiteDatabase db;
        string databaseName = "Benchmark_cs-SQLite.sqlite";
        db = new SQLiteDatabase(databaseName);
        DataTable table = db.ExecuteQuery("SELECT strIndex FROM Root");

the table.Rows.Count is 0, actually there are data in the file.

I debugged, the following line:

if ((resultType = csSQLite.sqlite3_step(vm)) == csSQLite.SQLITE_ROW)

it's false, resultType is SQLITE_DONE.

I just downloaded the source code, and I am using windows 2003.

Original issue reported on code.google.com by unruled...@gmail.com on 10 Aug 2009 at 8:35

GoogleCodeExporter commented 9 years ago 
With code checked in on 8/10/2009

?table.Rows.Count
10000

Please refresh later today confirm it is working

Original comment by noah.hart@gmail.com on 10 Aug 2009 at 12:52