SQL query is not returning @@IDENTITY

[tburk]

I can run a query through Microsoft SQL Server Management Studio that returns the identity value of the record just added, but when trying to execute the same query in Automation Anywhere the task fails somewhere in the 'Each Row in a SQL Query Dataset' loop. As you can see I have been trying to handle the errors by writing them to a log file but there is no logfile generated when this task fails.

Here is the query, INSERT INTO ProcessState (TaskID) VALUES ($TaskID$); select @@IDENTITY.

The atmn file is attached, please advise what is coded incorrectly.

Thank you.

[tburk]

I made it work, but, was wondering if this is best practice. Instead of executing one query it was split into 2 queries where the 2nd query returns the identity value.

Query1: INSERT INTO ProcessState (TaskID) VALUES ($TaskID$);
Query2: select @@IDENTITY;