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 <doch...@gmail.com> wrote: > > On Sat, Oct 24, 2015 at 5:58 PM, Scott Rossi <sc...@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ 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
