MySQL & Loop Requires Maximum Number of Records

[catchem35]

When Querying a MySQL Database and using the Loop option to select "Each row in SQL Query dataset" the column values are not assigned to the $Dataset Column(1)$ system variable.

Example (does not work):
Connect to 'Provider=MSDASQL.1;Persist Security Info=False;Data Source=ConnectionName'
Comment: Query below only works when "Maximum number of records to fetch" is specified.
Execute SQL Statement: SELECT email FROM public_records.email_dist_list
...
Start Loop " Each row in a SQL query dataset"
Message Box: "$Dataset Column(1)$"
End Loop
Disconnect from Database

However, I can get this to work if I specify a value for the "Maximum number of records to fetch" with the SQL Command options which should be an optional value.

Example:
Execute SQL Statement: 'SELECT email FROM public_records.email_dist_list
'... with 10 records to fetch

I welcome any suggestions on how I might correct or work around this. Thank you.

[forumsupport]

Hello,

This is very strange as we have never heard or seen such type of behavior before. However, let us investigate.

Can you please provide table design so we can try reproducing the scenario at our end?

In addition, at your end can you please try executing simple Select query like, 'Select * from tablename' without specifying maximum number of records and let us know the results.

It would help us investigate further.

[catchem35]

I have attached a simple table structure and atmn file with an example. The $Dataset Column$ variable only works if I go back in the the select command and specify the max number of records.

I also tried using a simple SQL statement and several variations without any different results. The example attached also uses a simeple SQl statement.

Thank you.

[forumsupport]

Hello,

We tried to reproduce the exact scenario at our end but it did not reproduce.

It seems you are using older version of Automation Anywhere so can you please try reproducing the same scenario on latest version of Automation Anywhere and if it still doesn't work for you then we need to look into the actual scenario so please provide your number and best time to reach at
Automation Anywhere - Open A Support Case

Alternatively, you can reach us at 1-888-484-3535 x 3.

You can download free trial version of Automation Anywhere 5.5.2 from our website:
Automation Anywhere - The Automation Software. Automate & Schedule IT & Business processes easily.

Hope that helps.