On Wed, Oct 9, 2013 at 7:02 AM, Dr. Hawkins <doch...@gmail.com> 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 use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
