I need urgent help on passing date as a variable in below sql query.
While we are writing it as date variable it is displaying error as “No Mapping exists from object type GenericValue to a known managed provider native type”
– c.containername = ‘17505’
AND convert(date,HML.TxnDate) =‘&TxnDate.ToString()&’
– year(HML.TxnDate) = 2018 – and month(HML.TxnDate) = 1
– and IAh.cscProductName is not null
and MLI.DefaultLot = '2018157531'
and TagName = ‘RMQtyTag’"
Could you please help with this issue.
Could you please send a screenshot of your Query inside the UiPath Studio?
And aren’t you missing a " there?
AND convert(date,HML.TxnDate) =’" & TxnDate.ToString()& "’
@Lucas.Pimenta Thanks for the reply.
If we use " (Double Quote), it is throwing an error as(String constants must end with a double quote).
Created the TxnDate variable type as ‘DateTime’.
Attached the query.
Please suggest us.
The double quote is mandatory so you can assign the variable through the String.
It’s possible to share the workflow (or the workflow just with the string) so I can check it out?
@Lucas.Pimenta attached the workflow.
CamstarDBsap.zip (1.4 MB)
Thanks for your help.
Resolved issue, by removing quotes for variable in query.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.