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