How to insert or update data into table by using tmysqlrow_1?

[Ashok200792]

how to Insert or update the data into table by using tmysqlrow_1 

QUERY:

"update CHECK_DATA SET FLAG='K' where FLAG='"+row1.invoiceno+"'"

show error,

Starting job FileProcess_Copy at 15:12 21/11/2017.

[statistics] connecting to socket on port 3914
[statistics] connected
Exception in component tMysqlRow_1 (FileProcess_Copy)
java.lang.NullPointerException
at local_project.fileprocess_copy_0_1.FileProcess_Copy.tFileInputDelimited_2Process(FileProcess_Copy.java:5779)
at local_project.fileprocess_copy_0_1.FileProcess_Copy.tFileList_1Process(FileProcess_Copy.java:1206)
at local_project.fileprocess_copy_0_1.FileProcess_Copy.tMysqlConnection_1Process(FileProcess_Copy.java:850)
at local_project.fileprocess_copy_0_1.FileProcess_Copy.runJobInTOS(FileProcess_Copy.java:12808)
at local_project.fileprocess_copy_0_1.FileProcess_Copy.main(FileProcess_Copy.java:12651)
[statistics] disconnected
Job FileProcess_Copy ended at 15:12 21/11/2017. [exit code=1]

[Ashok200792]

Thanks for Support .


Ashok

[Anonymous]

You're welcome.

[Anonymous]

Hello,

Could you please mark this topic as 'Solved' if this solution is OK with your issue?

Best regards

Sabrina