Apostrophe issue 1

[crossface]

The following code is giving me a problem due to the apostrophe in the string

Command contains unrecognized phrase/keyword

Name=='This is Mary's book'


How can I resolve this problem?

 

[Mike Gagnon]

Name="This is Mary's book"

Double quotes at the extremeties


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[crossface]

I am using the with a string &AppendedString The double quotes don't work

 

[crossface]

Here is my code that is having the issue

TempSelectedName=ALLTRIM(SelectedName)

AppendedString= "ALLTRIM(" + FirstField + ")=='" + TempSelectedName + "'"


replace ALL selected WITH .t. FOR &AppendedString


If SelectedName has an apostrophe in the string I get the error

 

[Stella740pl]

If your string can contain an apostrophe, don't use also apostrophes to enclose it (as you do it in your code). Use quotation marks or square brackets. Like this:

TempSelectedName=ALLTRIM(SelectedName)

AppendedString=[ALLTRIM(]+FirstField+[)=="]+ TempSelectedName+["]

replace ALL selected WITH .t. FOR &AppendedString

OR

TempSelectedName=ALLTRIM(SelectedName)

AppendedString="ALLTRIM("+FirstField+")==["+TempSelectedName+"]"

replace ALL selected WITH .t. FOR &AppendedString

 

[crossface]

Thanks

That worked great!!!!