R
robert.waters
How might one escape an SQL string for insertion into a table?
I have a multi-user Access db, with users that create their own
queries that need to be synced to every other user's frontends. To
accomplish this, I had previously created a 'query repository' - the
frontends are updated with the current query set using a push/pull to/
from that repository (querydefs are copied around). Unfortunately due
to a limitation of Acess, this causes query Created and LastUpdated
dates to be lost (reset with the current date). So, I'd like to track
the queries in a table, including their sql source. However, I do not
know how to escape the sql text so that it doesnt pollute the sql
INSERT string. I am currently encoding it to base64, but i am sure
there is a better way.
Thanks!
I have a multi-user Access db, with users that create their own
queries that need to be synced to every other user's frontends. To
accomplish this, I had previously created a 'query repository' - the
frontends are updated with the current query set using a push/pull to/
from that repository (querydefs are copied around). Unfortunately due
to a limitation of Acess, this causes query Created and LastUpdated
dates to be lost (reset with the current date). So, I'd like to track
the queries in a table, including their sql source. However, I do not
know how to escape the sql text so that it doesnt pollute the sql
INSERT string. I am currently encoding it to base64, but i am sure
there is a better way.
Thanks!