On 1/20/2017 4:55 PM, Bart Smissaert wrote:
These integer values are then bound like this:
sqlite3_bind_int lStatementHandle, ByVal c, ByVal CLng(vArray(r, c))
My guess: some CSV fields contain non-digit characters (perhaps
invisible control characters), and so numeric coersion fails on them,
and perhaps CLng() returns -1 to indicate failure. Another possibility
is that the variant contains boolean True value; VB6 represents it
numerically as -1
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users