Hi, I am Facing issue with extracting data from SQL Database. pls help me out

Help Studio
, ,
1

I need extract data from various columns in Sql Database.
1.One of the column with nvarchar datatype with numbers.
2. While in UiPath if am taking as string of that column and comparing it is nor working.
3. I converted to nchar variables to integer. but is showing validation error like this.
Invoke Process workflow: The following errors were encountered while processing the workflow tree:
‘Process’: The private implementation of activity ‘1: Process’ has the following validation error: Cannot assign from type ‘System.String’ to type ‘System.Int32’.
‘Process’: The private implementation of activity ‘1: Process’ has the following validation error: Cannot assign from type ‘System.String’ to type ‘System.Int32’.

2

@Lokesh_M2

So while comparining a string value to Integer it will always throws an issue
But you can convert using Cint(StringValue) = 32 then it will works

If this is not the issue, can you share some screenshots / more info?

Thanks,
Srini

3

Hi, Thank u for response, Actually my issue is
Two columns in SQL database with data with datatype nCharvar
No of personsroomA= 2
No of personroomB= 2

now i need compare data from these two columns in UiPath.

4

@Lokesh_M2

For that you can refer below post

You have to change the type Of String to Of Int32 and it will work

Hope this may help you

Thanks,
Srini