Put custom value in sql query doesn't work

PierrickB — Sat, 16 Nov 2024 03:20:35 GMT

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

Re: Put custom value in sql query doesn't work

PierrickB — Thu, 06 Feb 2020 15:13:55 GMT

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

topic Put custom value in sql query doesn't work in Talend Studio

Put custom value in sql query doesn't work

Re: Put custom value in sql query doesn't work