Yes, the SQL runs successfully on my database manually. There is something about AA that is not receiving the dataset after the insert has occurred.
I've removed the insert from the SQL completely and left everything else the same. That allows me to get a value which I put into a parameter. If that value = 1, then I run another SQL INSERT to put the data into the database... not a great solution but it's the best I could do considering the bug with AA.
|