I read 2 hours of “passing data in SQL query” but no solution work for me, so I just post my solution and hope you guys can help me with it
I would like to access my database and get the content of my Column “Mail”.
It iss for checking if a user is verified to start a robot.
I created a “read mail” activity and get the sender email. This works fine.
I assigned that value to strInternalEmail (because it was a generic value first and its now a string) and now i would like to use the strInternalEmail value to search in my db.
i created read db activity in UiPath to find the correct values… My DB is User with column UserID and Mail… Pretty simple…
“Select UserID From User Where Mail = '” + strInternalEmail+ “’”
I receive the error message :" read Mail from User : Syntaxerror in FROM-Klausel"…
What did i do wrong? I cant find a solution… - _-
Thanks for your help!