Some progress with this. Still get an error: unknown error, Extended error code: 100, but it all runs and get the right results and no crash. Problem was I did put the result of sqlite3_step in a VB Long datatype:
Dim lStepResult As Long lStepResult = sqlite3_step(lStatementHandle) Now I do instead: Dim lStepResult 'VB variant datatype RBS On Sun, Oct 18, 2015 at 10:16 PM, Bart Smissaert <bart.smissaert at gmail.com> wrote: > > Is that binary ? Or hex ? > > Normal decimal, it is the result of sqlite3_extended_errcode(lDBHandle) > > > Just to verify, can you download the SQLite shell tool and try to > execute the same sequence ? > > Not sure that is that simple as the code to produce the result is in an > ActiveX dll, not in sqlite3.dll. > > RBS > > On Sun, Oct 18, 2015 at 9:43 PM, Simon Slavin <slavins at bigfraud.org> > wrote: > >> >> On 18 Oct 2015, at 8:35pm, Bart Smissaert <bart.smissaert at gmail.com> >> wrote: >> >> > I get an error: unknown error, Extended error code: 100. >> >> Is that binary ? Or hex ? >> >> > I do understand that most likely the problem is somewhere in my VB6 >> code, >> > but I can't see it and maybe somebody can shed some light on this from >> the >> > SQLite side. >> >> Just to verify, can you download the SQLite shell tool and try to execute >> the same sequence ? >> >> Simon. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > >