I am late in blogging about this post. But NOW is the time, as this post just saved my 1/2 day. Seriously. Not kidding. I was stuck with one SQL query execution. There were records to be retrieved, but my code didn’t. After 5-10mins of frustrated troubleshooting, I remembered this post. I should have done that immediately then, but I didn’t.
I setup my VS Tools project to launch GP as instructed on this post and within 2 minutes I could find the issue.
This one deserves to be there on Microsoft Dynamics GP Cookbook (technical).