Is it possible for you to post the "offending" block of VBA code? Even seeing your list of steps, it might be easier to help if we can view the actual syntax.
Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -----Original Message----- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 7:06 PM To: [email protected] Subject: RE: [sqlite] How do I know sqlite_get_table is finished Good thought, but 1. I set the connection 2. get the array 3. dump it in the sheet 4. and then close the connection. The crash happens at number 2. I am sure I must be overlooking something simple here. The trouble is that this error is not consistent. RBS -----Original Message----- From: Guy Hachlili [mailto:[EMAIL PROTECTED] Sent: 01 February 2007 23:50 To: [email protected] Subject: RE: [sqlite] How do I know sqlite_get_table is finished Well... At 23:17 2/1/2007 +0000, you wrote: >Thanks, yes, I somehow didn't think my explanation made sense and in fact I >just had another Excel crash, caused by the same call to sqlite_get_table. > >I just can't understand why this is happening. >There is a valid connection, there is a valid SQL, the DB file is there and >working otherwise fine, etc. > >The wrapper works otherwise 100% perfect and I only have the problem in this >particular procedure. I guess there must be a VBA bug then, but I just can't >find it. Is it possible that you are using the array returned by the function after you close the database, and that the VB wrapper frees the data when the database is closed? If that is the case, you will probably get a crash as you are accessing a memory that was already freed. Guy ------------------------------------------------------------------------ ---- - To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ---- - ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
