i have an issue with my Execute Query. While executing i get the Error: Execute Query: Input string was not in a correct format.
I guess the string might be correct:
“Select EZUE_AA_DZEDR.m_id, EZUE_AA_DZEDR.CNO, EZUE_AA_DZEDR.AMOUNT_EURO, EZUE_AA_DZEDR.LV_DATE, EZUE_AA_DZEDR.FLAG_2 From EZUE_AA_DZEDR Where EZUE_AA_DZEDR.LV_Date = (select max(LV_DATE)- INTERVAL ‘1’ day from EZUE_AA_DZEDR) AND EZUE_AA_DZEDR.CNO = ‘01’”
(tested at SQL-Developer and it works, just added " " in UIPath-activity)
Maybe there is a limit of values or something which can be stored in a DT? Querys with smaller amount of values work like:
“Select max(m_id) from EZUE_AA_DZEDR”
Is someone able to help me with this issue?