TMSStoredProc RETURN_VALUE does not return negative number returned by stored procedure
Posted: Thu 22 Nov 2018 19:01
Hello,
I am new to DevArt, and migrating conectors to TMSXXXX, everything goes great until now!! I have a lot of SQL Server stored procedures, and by politics, when there are errors in the stored procedure (managed or not) we return a negative number, so we can know that the stored procedure was not executed sucefully. When whe use then Execute method and evaluate the params RETURN_VALUE, instead the negative number (i.e -10) I got an integer overflow number 4294967286, in every case.
Is there any way to get the correct RETURN_VALUE value whe returned the negative number ?
PD This works fine with TADOStoredProc and even with TFDStoredProc.
Thank you!
I am new to DevArt, and migrating conectors to TMSXXXX, everything goes great until now!! I have a lot of SQL Server stored procedures, and by politics, when there are errors in the stored procedure (managed or not) we return a negative number, so we can know that the stored procedure was not executed sucefully. When whe use then Execute method and evaluate the params RETURN_VALUE, instead the negative number (i.e -10) I got an integer overflow number 4294967286, in every case.
Is there any way to get the correct RETURN_VALUE value whe returned the negative number ?
PD This works fine with TADOStoredProc and even with TFDStoredProc.
Thank you!