jangoslackgit / sqlite4java

Automatically exported from code.google.com/p/sqlite4java
0 stars 0 forks source link

Inconsistent column numbering #23

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
SQLiteStatement.bind starts with 1, columnType, columnValue, etc. start with 0. 

Original issue reported on code.google.com by davidrib...@yahoo.com on 29 Dec 2010 at 11:12

GoogleCodeExporter commented 9 years ago
I'm not sure how to set this to a low priority. Sorry.

Original comment by davidrib...@yahoo.com on 29 Dec 2010 at 11:13

GoogleCodeExporter commented 9 years ago
I wholeheartedly agree this is ugly, however, this is consistent with the 
respective SQLite methods:

http://sqlite.org/c3ref/column_blob.html - columns start at 0
http://sqlite.org/c3ref/bind_blob.html - bound vars start at 1

Since sqlite4java is just a wrapper (although a smart one), we need to stick to 
the conventions and docs provided by SQLite.

Anyway, thanks for posting your opinion!
Igor

Original comment by ser...@gmail.com on 29 Dec 2010 at 11:24

GoogleCodeExporter commented 9 years ago
Makes sense to me. Thanks for the quick response.

Original comment by davidrib...@yahoo.com on 29 Dec 2010 at 11:54