What I typically do is: put "SELECT foo FROM tTableName WHERE (bar > 7) AND (animal<>'cat');" into tSQL replace "tTableName" with tTableName in tSQL -- assuming tTableName contains the name of a real table
Looks and reads a whole lot cleaner. Bob S On Oct 26, 2015, at 13:25 , Dr. Hawkins <doch...@gmail.com<mailto:doch...@gmail.com>> wrote: I seem to have mis-parsed that myself. There is a custom property (call it theProp) with a value like "SELECT foo FROM " & tableName & " WHERE (bar > 7) AND (animal<>'cat');" So those quotes and & are in the string to be evaluated. My understanding of parsing is that the first piece should evaluate to SELECT foo FROM the second to SELECT foo FROM and the third to WHERE (bar > 7) AND (animal<>'cat'); and when concatenated produce a string of SELECT foo FROM theRealTableName WHERE (bar > 7) AND (animal<>'cat'); _______________________________________________ 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