RE: [sqlite] Still Excel crash when running sqlite_get_table

2007-02-07 Thread RB Smissaert
:37 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Still Excel crash when running sqlite_get_table 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

RE: [sqlite] Still Excel crash when running sqlite_get_table

2007-02-07 Thread RB Smissaert
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 i

RE: [sqlite] Still Excel crash when running sqlite_get_table

2007-02-07 Thread RB Smissaert
ailto:[EMAIL PROTECTED] Sent: 07 February 2007 17:22 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Still Excel crash when running sqlite_get_table At 17:04 2/7/2007 +, you wrote: >Not sure now the zip file has come through to this forum. >I can see it, but I also got a message tha

RE: [sqlite] Still Excel crash when running sqlite_get_table

2007-02-07 Thread Guy Hachlili
At 17:04 2/7/2007 +, you wrote: Not sure now the zip file has come through to this forum. I can see it, but I also got a message that it wasn't allowed. Didn't get through the first time, did get through the second time. I tried my version of the VBSqlite3 DLL and it works, although I did

RE: [sqlite] Still Excel crash when running sqlite_get_table

2007-02-07 Thread RB Smissaert
07 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 +, 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 an

RE: [sqlite] Still Excel crash when running sqlite_get_table

2007-02-07 Thread RB Smissaert
@sqlite.org Subject: Re: [sqlite] Still Excel crash when running sqlite_get_table Hmmm... At 13:38 2/7/2007 +, 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 th

RE: [sqlite] Still Excel crash when running sqlite_get_table

2007-02-07 Thread RB Smissaert
Still Excel crash when running sqlite_get_table Hmmm... At 13:38 2/7/2007 +, 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. >Wo

Re: [sqlite] Still Excel crash when running sqlite_get_table

2007-02-07 Thread Guy Hachlili
Hmmm... At 13:38 2/7/2007 +, 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 da

[sqlite] Still Excel crash when running sqlite_get_table

2007-02-07 Thread RB Smissaert
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. Thanks. RBS