The single quotes do not need to be escaped, as Access can deal with
them. However, the double quote *will* need to be fixed.
You could process your string parameter and make it read "'f" & chr(34)
& "unf'" and substitute that for your ________ (including the " marks).
That pushs the problem into Access.
Posted At: 17 January 2000 10:17pm
Posted To: microsoft.public.sqlserver.odbc
Conversation: ODBC Escape Sequence
Subject: ODBC Escape Sequence
I would like to a find a field in an access 97 database
via odbc/mfc/mvc++ with the value (including "'"s)
Which escape sequences in an CRecordset-query consisting of
CString s("SELECT * FROM table AND table.field LIKE _________");
must I use?
Bavarian Research Center for Knowledge Based Systems
Am Weichselgarten 7, D-91058 Erlangen