I created a huge SQL Server stored procedure from within the *VB IDE* and is part of the data environment. I have the entire procedure sandwiched between a BEGIN TRANSACTION and a COMMIT. It does not return a recordset. I have in the VB procedure something like the following:
Public de As New DataEnvironment1
de.sp_updateSubmitted date
The problem is how do I know if the entire transaction succeeded or failed. If I add an OUTPUT PARAMETER to the stored procedure VB complains. If I try:
nRetVal = de.sp_updateSubmitted date - VB does not like that either.
Ernest