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’.
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
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.
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