If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sql string as field data; ado?
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! |
Thread Tools | |
Display Modes | |
|
|