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.