Problems when looping through a dataset

[dennisr]

Ok, here is my issue:

I've established my connection and queried our iSeries to return a dataset.
I've inserted my Start Loop "Each row in a SQL query dataset" step.

Within the loop I perform some other SQL select statements, retrieving single records, from different tables in the same iSeries database. I've place conditions after those select statements and if the current record meets all the conditions, then I perform inserts and an update to the current record in the original SQL statement that created the dataset that I'm looping through.

When this occurs, and the next dataset record in the loop is read, the data in the record seems to disappear. Where I expect to see data displayed in a message box for the record, nothing appears. The process continues to loop through records, but the subsequent records after a successfully processed one do not appear to have any data. Any suggestions??? Anyone know of anying issues with updating to a record within a loop?

Thanks, Randy

[forumsupport]

Hello Randy,

Can you please try the same thing in latest version, which has nested loop support for the Database commands using session functionality so you can retrieve data using nested loops from different databases.

You can download the latest version of Automation Anywhere Server from, Automation Anywhere Server - The Leading Automation Software

Hope that helps.

[dennisr]

If I don't find another solution then I'll propose this to our infrastructure group.
Thanks,
Randy