On Wed, Oct 9, 2013 at 7:02 AM, Dr. Hawkins <[email protected]> wrote:
> You're using the wrong escape. > > Inside a string, you need a double single quote, not a backslash. > > It's worth keeping a preSql() function around, like: > > function preSQL pSQL > replace "'" with "''" in pSQL > if pSQL is empty then > return "NULL" > else > return "'" & pSQL & "'" > end if > end preSQL > Thank you, Dr Hawkins. Problem solved. Now if I can just get my brain to do an UPDATE. -- Paul _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
