addslashes

[Craig Tooker]

On 08/26/2010 10:27 AM, Richard Kreiss wrote:
> 
> 
>> -----Original Message-----
>> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-
>> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Fairlight
>> Sent: Wednesday, August 25, 2010 7:42 PM
>> To: filepro-list at lists.celestial.com
>> Subject: Re: addslashes
>>
>> At Wed, Aug 25, 2010 at 06:58:02PM -0400 or thereabouts,
>> suspect Jose Lerebours was observed uttering:
>>> On Wed, Aug 25, 2010 at 4:39 PM, richard <richard at appgrp.net> 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.
>>
>> Personally, I'd loop through the string with INSTR(), take everything
>> before the offending character and put it in an uncast variable, put the
>> requisite escape character for the offending character, then the offending
>> character itself onto the new buffer, and then start from the character
>> after that with INSTR() on the original string.  Rinse, repeat until done.
>>
snip...
>> mark->
> 
> 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().

Craig
> 
> 
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net
>   
> 
> 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list