How to use ' in a query??? 1

[logge]

Hi!

I have a database containing filenames, and some of them uses the ' character. (ex. "peter's file.txt&quot
I'm using a MFC recordset to connect to the database.

Problem is that when I want to filter records Access don't like strings with ' at all, since it thinks this is the end of a string, and not a character in the string.

Does anyone know how to fix this?

Thanks,

Peter Logarn

 

[Aivars]

Post example of code for data filtering!

Aivars

 

[logge]

Sure!

If I try to do something like this:

m_pSet->m_strFilter = "TYPE = 'Peter's file.txt'";
m_pSet->Requery();

I get an exception when I do the Requery() call,
saying something about a invalid query.

m_pSet is from a CRecordSet derived class.

I hope this will help.

 

[Frink]

Hallo,

Try replacing the ' String delimiters in the SQL with "". You have to do "" rather than " so Access knows it's the " character, not the end of the string. Like this:

m_pSet->m_strFilter = "TYPE = ""Peter's file.txt""";

- Frink

 

[logge]

Sorry, it does not work.

It just says "Syntax error in string in query expression 'TYPE = Peter's file.txt ORDER BY ID'.

Peter

 

[raskew]

You can find potential solutions to this problem at:

http://support.microsoft.com/support/kb/articles/Q147/6/87.ASP

and

http://support.microsoft.com/support/kb/articles/Q178/0/70.ASP

 

[Frink]

Hallo,

Sorry about that. I'll summarise the suggested FAQ, by saying just add more "s until it works.

- Frink