parentheses within string break value()

[Bob Sneidar]

As always, put it into a variable, copy the contents of the variable to the clipboard, either programmatically, or from the debugger, paste it into an SQL editor, and it should show you where the error occurs. 

Bob S


> On Oct 25, 2015, at 08:19 , Dr. Hawkins <dochawk at gmail.com> wrote:
> 
> On Sat, Oct 24, 2015 at 5:58 PM, Scott Rossi <scott at tactilemedia.com> wrote:
> 
>> Is 123 a function?  If yes, I believe you need to remove the quotes
>> surrounding it.
>> 
> 
> Just some text.  I'm trying to concatenated strings, but livecode is
> looking at punctuation inside of the quoted literal.
> 
> That was a simplified version; the actual is something like
> 
> "SELECT uniqDNA FROM " & dhtbl_dna & " WHERE (cname||cadr NOT NULL) AND
> (chrType <> 'K');"
> 
> 
> where dhtbl_dna holds a table name and the rest are *supposed* to be string
> literals
> 
> -- 
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode