Unreliable indexing

Oct 26, 2011 at 10:42 AM


I have noticed indexing for binding and getting data from columns is not consistent in certain scenario.
If you use binding and than BindInt for a simple table, than ColumnAsIntAt should be zero based.
On a bit more complex table structure I have to use  +1 on ColumnAsTextAt.

However if I use direct input (insert everything into string) than it is zero based again...

Also BindInt seems to have a memory issue on a bit more complex table structures. (direct input works or text only binding)
Indexing must be always consistent from zero or one althrough entire API!

I like your API but without access to your source and with this bugs I cannot use it well. :(

Oct 28, 2011 at 4:05 PM
This is how SQLite works. The wrapper doesn't change the index' base.