Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Tue, May 8 2007 12:38 AM	Permanent Link
"Mark Warren"	Is there any way to apply a filter when the filter text contains a single quote (apostrophe)? I am getting the filter text from a database field containing CD artist names and some of the names contain an apostrophe, ie. O'Jays. This causes an error due to the extra single quote - any ideas on a solution for this? Thanks, Mark Warren
Tue, May 8 2007 3:02 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Mark You have to double up the quotes eg O''Jays where '' is two ' not one " Roy Lambert
Tue, May 8 2007 5:17 AM	Permanent Link
Arnd Baranowski	Mark, if you use QuotedStr(DataField.AsString) in the expression then it should work. Arnd Mark Warren wrote: > Is there any way to apply a filter when the filter text contains a single > quote (apostrophe)? > > I am getting the filter text from a database field containing CD artist > names and some of the names contain an apostrophe, ie. O'Jays. This causes > an error due to the extra single quote - any ideas on a solution for this? > > Thanks, > > Mark Warren > >