Hello, hope everyone had a great new year start, i have the next situation:
i’m trying to save data into a sqlite database, to doing it, i’m using the next command:
Query INSERT INTO Workitems (rut_emp, year, month, filename, process_date) VALUES (‘${rut_prefix}’,${year_report},${month_report},‘${file_route}’,‘${ok_file_time}’);
the values came from a regex over a file, and later transferred into a work-item json, and that part works like charm, but in the batabase, while i get the pass over the execution, there’s no new row on the sqlite file
i have read over a similar situation on Stack Overflow, and there recommends using Execute SQL String, but as far as i can tell over the library, that’s a deprecated keyword, and there’s other option: Execute sql script, but i’m not sure if i use that option will take the saved values from the regex
