Variable type error

[Luca2 (Luca)]

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]

Hi,

Can you try the following expression?

ID = CInt(CurrentRow("id"))

Regards,

[vishnuvarthanp (vishnuvarthan)]

Hi,

Can you check what is the variable type of ID?

[Luca2 (Luca)]

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

[vishnuvarthanp (vishnuvarthan)]

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

Variable type error

Hi, Can you try the following expression? ID = CInt(CurrentRow("id")) Regards,

[Gokul001 (Gokul Balaji)]

Hi @Luca2

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

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

Regards
Gokul

[postwick (Paul Ostwick)]

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