Good idea, I have checked for this but will double check again. The problem arises already with the very first element of the variant array and my log shows the problem:
logged before the bind: vArray(0, 0): 1 logged after the first row has all the values bound: bound value: -1 There are no Boolean True values in the variant array. RBS On Fri, Jan 20, 2017 at 10:57 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users