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

Reply via email to