Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i try to use custom code in sql query in tDBROW to delete data but it's not working...
Here is my request in tDBRow :
"DELETE FROM `pricelistdetailed` WHERE `MonthYear` = " +TalendDate.getDate("YYYY")+ "-"+ TalendDate.addDate(TalendDate.getDate("MM") , "MM", -1,"MM")
I got no error when i execute the job.
for testing i used a tMsgBox to display the custom value :
"Hello world!" + TalendDate.getDate("YYYY")+ "-"+ TalendDate.addDate(TalendDate.getDate("MM") , "MM", -1,"MM")
This work, it display : 2020-01
It's someting miising?
Thanks,
Pierrick
Hi,
i find the solution there is missing quote at the end of the line :
"DELETE FROM `pricelistdetailed` WHERE `MonthYear` = ' " +TalendDate.getDate("YYYY")+ "-"+ TalendDate.addDate(TalendDate.getDate("MM") , "MM", -1,"MM") +" ' "
Regards
Hi,
i find the solution there is missing quote at the end of the line :
"DELETE FROM `pricelistdetailed` WHERE `MonthYear` = ' " +TalendDate.getDate("YYYY")+ "-"+ TalendDate.addDate(TalendDate.getDate("MM") , "MM", -1,"MM") +" ' "
Regards