escape special character
Example query which will fail:
INSERT INTO `log`
(`logger_name`, `time`, `level`, `source`, `message`, `error_code`, `error_message`)
VALUES
('test123', '2022-09-07 13:02:27.679', 'CRITICAL', 'Test My VI.vi', 'Some message', 568006, "'get_SUPPLY_voltage' tag timed out. Expected '3600.000000'; Received '3.478009');
-
create a ''escape special character.vi'' which scans the input string for SQL meta characters '
and\
and escapes them using another\
in the output string -
check best implementation place (db-connector vs. abstract engine)
Edited by Alexander Elbert