I tried this solution to insert data to MySQL database but I am getting below error. data is inserting to MySQL database but each insertion it throws this error.
My code as follows
LET V_ROWS = NoOfRows('table');
FOR V_ROW = 0 TO V_ROWS - 1
LET V_FIELD4 = Peek('Impact',V_ROW,'table');
LET V_FIELD5 = Peek('Urgency',V_ROW,'table');
LET V_FIELD6 = Peek('Priority',V_ROW,'table');
SQL INSERT INTO kedb.incidents(Impact,Urgency,Priority) VALUES('$(V_FIELD4)','$(V_FIELD5)','$(V_FIELD6)');
NEXT;