Unable to run a Sql Server statment using a Cursor

Help Studio
, ,
1

Hello,
I am using a UiPath.Database.Activities.ExecuteQuery module to run a sql statement that contains a cursor. I am getting the error message, "Incorrect syntax near ‘ship2change’
for this command
DECLARE ship2change CURSOR FAST_FORWARD

Does anyone know of a way to work with this?
Thank you

2

I found a work around. I bundled my sql statement into a stored procedure and instead ran the stored procedure from UiPath. It worked perfectly.

1 Like