SQL with Call and for-each

[Former Member]

Hi All,

I have a sql call that returns more that one record and for each record I must transform the data into an xml format and send it to a .NET call. I succeeded in a single line on a real time trigger from SAP B1. But the sql call has multiple records. please help.

I get the following error:

Please help,  Brenden Draper

[Former Member · Accepted solution]

Hi All,

I am using SAP 9 PL4 and you get this error when your query result returns allot of rows. The processing still works but you can not use the red debug arrows properly on the atoms between your for each statement.

Regards, Brenden Draper.

[Former Member]

Hi All,

This has something to do with my SQL Call query. When I test it with another query on another table it works 100%.

Regards,  Brenden Draper

[Former Member]

Why can't I debug my atom in the for-each. I keeps giving me An error has occurred in the script ?

Please help, Brenden Draper

[former_member203816]

Hi Brenden,

When you got the error for script error then plz add the servername or localhost (if you use internall) in tools -> compatibility view settings.

Thanks,

Tushar