Variable type error

Luca2 · January 12, 2023, 2:04pm

hello i hope you are well

I need to get the id variable from a database and store it in a variable in the UiPath, it is auto-incremented within the database.

However, I’m getting this error, could you help me?

“id” INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
This is the bank id line

Yoichi · January 12, 2023, 2:09pm

Hi,

Can you try the following expression?

ID = CInt(CurrentRow("id"))

Regards,

vishnuvarthanp · January 12, 2023, 2:09pm

Hi,

Can you check what is the variable type of ID?

Luca2 · January 12, 2023, 2:10pm

hi, this is in the second image, it is int

vishnuvarthanp · January 12, 2023, 2:12pm

You are trying to assign a string value to a int variable . Hence the error.
Please check this.

Gokul001 · January 12, 2023, 2:12pm

Instead of using CurrentRow("id").ToString try to use Cint

ID = CInt(CurrentRow("id").Tostring)

Regards
Gokul

postwick · January 12, 2023, 2:13pm

Look at the first line of the error in the Output. The problem is with your Execute Query activity, not the Assign.

system · January 15, 2023, 2:13pm

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.