i tried something like this system.db.runPrepUpdate(“INSERT INTO ABC(ROW_ID,TRXN_DATE,SHIFT,WORK_STATION_ID,PLANT_ID,SUB_LOCATION,CUSTOMER_NAME,OA_NUM,PARENT_MNO,CHILD_MNO,QUALITY,UNIT_WGT,TRACE_NO,BIN_NO,BIN_POSITION,STATION_NAME,STATUS,GB_STATUS,OPR_NAME,SUPR_NAME,COMPLETED_ON,CREATED_BY,CREATED_ON,ACTIVE,PF_ROW_ID)SELECT (int(ROW_ID),timestamp,unicode(shift),unicode(workstationid),unicode(plant_id),unicode(sub_location),unicode(‘null’),unicode(‘null’),unicode(‘null’),unicode(‘null’),unicode(‘null’),unicode(‘null’),unicode(traceno),unicode(binnum),unicode(‘null’),unicode(‘null1’),unicode(status),unicode(‘PENDING’),unicode(‘null2’),unicode(supervisor),timestamp,unicode(createdby),timestamp,unicode(active),int(v_PF_ROW_ID)) WHERE NOT EXISTS (SELECT * FROM ABC WHERE PLANT_ID = ? AND TRACE_NO = ?)”,[unicode(plant_id),unicode(traceno)])
and this gives a error as given below
