I am uploading data to a Microsoft SQL database, and I decided to use a thread to allow the user to see the progress. All code worked fine without threads, but inside the thread. Below is the code that is causing problems. As I step through the code in the debugger, when I hit the first line of code below, I am sent to the Window, and I am kicked out of the debugger, as if all code has completed executing. Any ideas.
rs = app.dbSQL.SQLSelect(SQL) If app.dbSQL.Error Then //Put messages in an object to be displayed outside of the thread lbClaimsMessagesCol1.Append("Fail - Claim sheet name not found in database") lbClaimsMessagesCol2.Append("0") End If