> On Tue, Feb 4, 2020 at 5:38 PM Doug <dougf....@comcast.net> wrote:
> > > You're twisting my point here. I obviously want the reverse,
> > > I want the database types to "drive" the binding done. 1-to-1.
> > > Because even if binding a different type would work, via
> SQLite's
> > > own implicit conversion, I don't want that, because it's
> hiding a
> > > bug in the code most likely instead. --DD
>
> > Is the code inadvertently putting quotes (') around in integer
> value [...]?
>
> I'm talking about "real" binding here:
> https://www.sqlite.org/c3ref/bind_blob.html
> In C/C++, you could mess up your col indexes when binding, or bind
> incorrectly for some other reason, and "strong static typing" is more
> likely to find those, via SQL failures, than SQLite's default
> flexible-typing, that accepts any value in any typed column,
> unless you have these explicit CHECK+typeof constraints. --DD
So you are talking about a bug in your code where you inadvertently called:
sqlite3_bind_text(sqlite3_stmt*,int,const char*,int,void(*)(void*));
instead of
sqlite3_bind_int64(sqlite3_stmt*, int, sqlite3_int64);
and you want SQLite to tell you about it.
I have a hard time seeing how you could make that kind of coding error, given
the different parameters and types in the calls.
Doug
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
