I have used an assign activity…to assign a value to variable.
And I’m getting this error occasionally.
what is this error and why it is occurring ?
Please help me.
Hi @Praw1n
Can we know what type of variable you re creating and what type of value are you passing in assign with screenshot so that we may able be sort it out Quickly?
Regards
I’m using… Dt_Row as a variable of type DataRow.
Dt_Row = Dt1.Select(“[Column1]= '”+VariableName+“'”)
where, VariableName is a row item of Dt2(Column1)
Dt_Row = Dt1.Select("[Column1]= '"+VariableName+"'")
VariableName is string variable ?
Dt_Row is Datarow[]?
Regards,
Arivu
Yes, It is a string. @arivu96
Dt_Row = Dt1.Select("[Column1]= '"+VariableName+"'")
if you are using above query then its correct can you send the error screenshot
Regards,
Arivu
Please send the syntax screenshot
The syntax is correct can you pls check the Pur_item having any special char in the string.
please print the value and check
Regards,
Arivu
While executing the program…
I’m getting this error when the
Pur_Item = FFKM ‘O’ RING FOR 70MM DOUBLE MECHANICAL SEAL
Need to remove the special char before you apply filter because in dt.select filter we are using ’ char to specify the string value
Try below query
From p in GRN_Dt.Select() where p("Item").Equals(Pur_Item) Select p).ToArray.CopyToDataTable()
Regards,
Arivu
1 Like
Do you mean ‘O’ is a special character ?
But we are assigning values to Pur_Item Dynamically. How can we rectify this ???
Hi,
Can you try the following expression? This escapes single quote.
GRN_DT.Select("[Item]='"+Pur_Item.Replace("'", "''")+"'")
Regards,
1 Like
Pls remove the ( before p.
(from p in GRN_Dt.Select() where p("Item").Equals(Pur_Item) select p).ToArray().CopyToDataTable()
are you using c# or vb.net
Regards,
Arivu
Anil_G
ashokkarale
Yoichi
Jon_Smith
A_Learner
ewanc1
Sylvain_FARNAULT_131
CHEN-CC
Eric_Alvarado
azeem_rosli