addslashes

Jose Lerebours fpgroups at gmail.com
Fri Aug 27 07:42:49 PDT 2010


On Thu, Aug 26, 2010 at 6:48 PM, Craig Tooker <craig at cwtsoftware.com> wrote:
>>>>> Is there a simple way in filepro to turn "Robert's golf clubs" into
>>>>> "Robert\'s golf clubs"?
>>>>
>>>> You could try using replace() function or simply write a routine that
>>>> seeks out these characters, splits the string and escapes the
>>>> characters.
>>>
>>> Is REPLACE() a new function in 5.0 or 5.6?  It's not in the 4.8 docs.
>>>
>>
>> Not aware of a replace() as a normal filepro function.  In checking the 5.6
>> docs, replace appears in the odbc version.
>>
>> This is not part of fpsql if that is what is being used for a query.
>
> I believe what you are looking for is XLATE().
>

You are right ... this is what I meant to suggest but since PHP was
mentioned on the original post, I ended up suggesting a PHP function
or family of functions.  Thinking one thing and typing another.

I stand corrected, thank you all for your observations.

Regards,


Jose

PS:  Mark, if the data is written back to filePro  is what I meant
about the possibility of truncating some of its content.  I know, I
made no distinction so left to interpretation one could easily see why
my observation was without merits.  Thank you for pointing that out as
well.


More information about the Filepro-list mailing list