Hi Forum members,
After converting windows legacy to windows. Facing this error for update query passed to a variable through assign activity.
Quick help will be aprreciated.
Thanks in advance
2024-09-16
Studio
This error is so confusing,
This is the insert and update query.
Error:
Compiler error(s) encountered processing expression ""Update
(12) : error BC30035: Syntax error.
(13) : error BC30035: Syntax error.
(1) : error BC32043: Too many type arguments to ‘Func(Of Out TResult)’.
(2) : error BC36625: Lambda expression cannot be converted to ‘Expression(Of Func)’ because ‘Expression(Of Func)’ is not a delegate type.
From what I observe the double quotes are not properly escaped everywhere
So to escape a double quote you need to use double of them ("") also when you want to use variable you have to close the string as well then triple
Eg: Txt_BOTstatus+""",TO_DATE("""+Txt_AlertDateTime
Hope this helps
Cheers
Tried changing the queries to complete double quetes as explained. Same error while compiling.
error BC32043: Too many type arguments to ‘Func(Of Out TResult)’.
(2) : error BC36625: Lambda expression cannot be converted to ‘Expression(Of Func)’ because ‘Expression(Of Func)’ is not a delegate type.
Please help. Thanks in adv!
Can you please open advanced editor or hover over the wuery and take screnshot and show
Or copy the exact string you gave in the field and paste it using performatted text(</>) option in the menu
Cheers
Hey Anil, Thanks for replying,
Windows legacy to Windows conversion made this simple queries into an error.
Any other way to make this work around?
I cannot attach screenshot here, because of privacy policies.
thanks in adv, Cheers.
Try to delete the newlines and give everything in a single line
Also just to make sure open the advanced editor and paste the full string there…
Cheers
I changed the query by splitting it into multiple assign acitivity and passed SQL query as concatenated variables.
It is working Fine now.
Thanks for the ideas, Anil.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.