I cannot find the answer to a simple question.
I have a table with a field defined as text. This field stores a number of SQL statements that are called upon to be executed on a dataset.
The problem I have is loading a record into the table when the SQL statement has a ' in it. For eaxample:
INSERT INTO TABLE 'tblStoredSQL' values ('SELECT * FROM tblJunk WHERE name = 'example'')
The insert statement requires the use of the ' and the stored SQL statement has the ' in it as well.
What to do?
Thanks for responses.