hi , i want to pass the dynamic values in SQL server from UiPath,
[dbo].[PriorClaimsSearch_Demographics] "KIARA ",“WILLMS”,“199212”,“32197”,“6413”,“GA”,“kha”,“TriTerm Medical”
from "KIARA to Medical " all the values are dynamic
plz help.
@Anil_G not having clarity how to do this …m using execute query for this
In execute query where you give the query …you will see a plus icon…click on the plus icon and click on advanced editor…
In that "[dbo].[PriorClaimsSearch_Demographics]""" + variable1 + """,“WILLMS”,“199212”,“32197”,“6413”,“GA”,“kha”,“TriTerm Medical”
Like this
Basically a string can be concatenated with another atring or variable using plus…
Double double quotes are used to escape the double quotes inside a string
Hope this helps
Cheers
As in screenshot u find now i am passing the the hardcoded value in parameter, this I want to change dynamically
Awesome if you have already added parameters…then instead of your hardcoded values assign variables there…nothing else changes…parameters need not be changed
If you already have variables assign them
If you want to run in loop then use currentrow("Columnname").ToString
Cheers
like this i have given the variable name only (without using any assign activity with variable name and its value)
Yes this is how you would assign the variables and the values needs to be assigned either in assign activity…or needs to be taken from some where before coming to this activity
If you have a user input then you can add Input dialog boxes and assign outputs to variables there
cheers
if i give assign activity with variable name and its value then also it act as a constant value only …i want dynamic value
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
sharazkm32
mively
lrtetala
Sathish_Kumar_S
sonaliaggarwal47
V_Roboto_V
pikorpa
prashant1603765
Parvathy