On Fri, May 20, 2016 at 12:24 PM, Mike Kerner <mikeker...@roadrunner.com> wrote:
> That's what I do when I have an indeterminate number of keys, or if I am > writing generic code that handles data from dissimilar tables in a similar > way. > The more I think of it, it would become a nightmare to build the array. I'm indeed building from dissimilar pieces. My raw code might have the general SELECT statement, using a global variable for the table name , then adding a WHERE which pulls filenames and conditions from a custom property of the group to be rendered. Similarly, the ALTER will draw from those same custom properties, and add some calculated values. I'd pretty much have to parse my SQL statements with livecode, and have some interesting and repeated code or functions and variables to reset the variable index, as well as a reverse index from variable name to numeric key of the index to be passed. > Do what you want, but best practice (with good reason) seems to still > be to use parameterized queries except where you cannot. > > -- 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
