********************************
** ORIGINAL AUTHOR : Arjen Baart - arjen@andromeda.nl
** CREATION DATE : Jul 31, 2003
-** LAST UPDATE : Jul 31, 2003
+** LAST UPDATE : Mar 14, 2015
** MODIFICATIONS :
**************************************************************************/
** PARAMETERS :
** RETURN VALUE :
**
-** DESCRIPTION : Insert backslashes before single quotes.
+** DESCRIPTION : Double backslashes and single quotes as per SQL syntax.
**
** VARS USED :
** VARS CHANGED :
** FUNCTIONS USED :
** SEE ALSO :
-** LAST MODIFIED :
+** LAST MODIFIED : Mar 14, 2015
**=========================================================================
*/
for (i = 0; i < ~s; i++)
{
- if (s[i] == '\'' || s[i] == '\\')
+ if (s[i] == '\\')
{
s(i,0) = "\\";
i++;
}
+ if (s[i] == '\'')
+ {
+ s(i,0) = "'";
+ i++;
+ }
}
return s;