addslashes

Jose Lerebours fpgroups at gmail.com
Wed Aug 25 15:58:02 PDT 2010


On Wed, Aug 25, 2010 at 4:39 PM, richard <richard at appgrp.net> wrote:
> I have a need to create some sql queries using filepro.
>
> My problem is that some of my text includes apostrophes and other chars.
> that "break" the query.
>
> In php there is a command called "addslashes".
>
> 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.

One thing comes to mind, you may truncate some of the field content by
inserting escape characters ...

There might be a way to simply dump the content to a text file, run a
shell script to do a global search and replace and read back the final
output.

Regards,


Jose Lerebours
954 559 7186


More information about the Filepro-list mailing list