The trouble always starts before I deal with the array, so I am sure that the trouble is not there. There are only 2 places where I have seen the trouble occur: 1. When I call sqlite_get_table 2. When I assign the array produced by sqlite_get_table to the wrapper function.
Yes, this is a catastrophic Excel crash, so no useful error message. I do get the option to debug in VC6++ and that always points to this bit of assembly: 77124CB4 8B 40 FC mov eax,dword ptr [eax-4] Something to do with OLEAUT, but that doesn't help me much. It looks the trouble doesn't happen when I do exactly the same with for example sqlite_master, so it looks there is something wrong with that table and I am going to have a look that now. Very puzzling and a right pain. RBS -----Original Message----- From: Trey Mack [mailto:[EMAIL PROTECTED] Sent: 02 February 2007 18:30 To: sqlite-users@sqlite.org Subject: Re: [sqlite] How do I know sqlite_get_table is finished > The function ArrayToSheet has nil to do with SQLite and I left that out. Ah, but that's where you access the variant array. That can be tricksy. Do you always access that variant array (arr) in the range (0 To NumRecords, 0 To NumColumns - 1) where the row arr(0, *) holds the column names, and UBound(arr, 2) is NumColumns ?? Also, when you say "crash", I assume you mean catastrophic-style, so you don't have a specific error number or description. Correct? - Trey ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------