It looks this crash only happens if the data in one one array element exceeds about 4000 characters or more precisely when the data in one element (row and column) of the database exceeds about 4000 characters.
Maybe after all this is not a SQLite problem, but a VB problem and maybe VB arrays can't handle this, making Excel crash. As SQLite can handle large blob data it must be very unlikely indeed that SQLite is to blame. Will see if there is anything known about this in VB/VBA. RBS -----Original Message----- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: 07 February 2007 16:16 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Still Excel crash when running sqlite_get_table The trouble is that after dropping some tables and doing a VACUUM to make the file smaller the crash doesn't happen, despite that table still being the same. I will attach the zipped db in any case although this particular table (table called SQL) didn't actually cause a problem. RBS -----Original Message----- From: Guy Hachlili [mailto:[EMAIL PROTECTED] Sent: 07 February 2007 15:40 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Still Excel crash when running sqlite_get_table Hmmm... At 13:38 2/7/2007 +0000, you wrote: >Still having a problem when selecting data from one particular table with >the VB wrapper dll SQLite3VB.dll. >It is only a small table and I just can't see why there would be a problem. >Would anybody be willing to have a look at this table? >The zipped database file is only 15 Kb. Nothing attached... can you post it somewhere for download? Guy ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
