Insert Into MSACCESS
Posted on 2006-05-02
I have a table with only 2 fields (id=autonumber, sql=255 text)
I want to do an insert but access gives me a syntax error:
CString statement = "INSERT INTO MYTABLE(SQL) VALUES('sql statement with 'single qoutes'...')";
I think it is complaining with what's in the values where it is containing single qoutes. What is the correct syntax when a field value contains single qoutes?