1. Tony Fahlberg
  2. SnapDevelop
  3. Thursday, 6 February 2020 00:07 AM UTC

Hi - I am receiving an "Error: Index was outside the bounds of the array." when converting a datawindow that uses a stored procedure with 3 parameters to a C# Model.  I believe I tracked down the issue to my retrieval arguments. In my use of this stored procedure I am always passing in 0 for the first argument therefore had removed one of the retrieval arguments and hard-coded 0 in the call (see below).  That datawindow fails to convert with the error mentioned above.  When creating the same exact datawindow but using 3 retrieval arguments corresponding to my stored procedure parameters, I was successfully able to covert it.

 

FAILS:  procedure="1 execute dbo.myprocedure;1 @z_sql_log_flag =0, @case_id = :case_id, @report_inst = :report_inst" arguments=(("case_id", string),("report_inst", string))  sort="type_id A sequence A " )

 

WORKS: procedure="1 execute dbo.myprocedure;1 @z_sql_log_flag = :z_sql_log_flag, @case_id = :case_id, @report_inst = :report_inst" arguments=(("z_sql_log_flag", number),("case_id", string),("report_inst", string))  sort="type_id A sequence A " )

 

I am wondering if this is expected behavior or an issue with the conversion. 

Thanks, Tony

 

Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Thursday, 6 February 2020 16:24 PM UTC
  2. SnapDevelop
  3. # 1

Hi Tony,

I think it's an issue with the conversion and it should be fixed.

Kindly please report it via our support ticketing system to ensure it is being properly tracked at https://www.appeon.com/standardsupport/

Regards,

Logan

Comment
  1. Armeen Mazda @Appeon
  2. Thursday, 6 February 2020 18:04 PM UTC
Hi Tony, Just to clarify, Logan doesn't think this is a problem with your code. He thinks it might be a bug with the converter tool itself. So he wants you to open a support ticket so the product team can investigate.
  1. Helpful
  1. Tony Fahlberg
  2. Thursday, 6 February 2020 18:33 PM UTC
Created the following bug. - Thanks



Bug 4043 - Datawindow Converter - Error: Index was outside the bounds of the array.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.