On Fri, Nov 14, 2014 at 9:21 AM, Peter Haworth <p...@lcsql.com> wrote:
> revDataFromQuery(,,17,"SELECT * FROM vader_darth______001_dna;") Somehow, an earlier version of my reply was sent. Here's what I meant to send. Knowing that you used the message box makes a big difference, Everyone who has checked this out used a script. I was surprised your statement worked at all in the message box since revDataFromQuery is a function and seems like it should need a "put" or "get" or "set, so I tried various LC versions, with/without semicolon, with/without "put", all in the message box. LC 5.5 All combinations of put/semicolon worked. LC 6.1 No put, with semicolon, failed "error executing expression" No put, no semicolon, worked With put, with semicolon, failed "can't find handler" With put, no semicolon, failed "can't find handler" LC 6.6 No put, with semicolon, failed "error executing expression" No put, no semicolon, worked With put, with semicolon, failed "can't find handler" With put, no semicolon, worked If it had something to do with the new SQLite library, there would have been an SQL error message but it never gets as far as executing revDataFromQuery. My feeling is that something changed in the message box parsing routines and the semicolon is being taken as a separator between two statements. However, bottom line is that all works fine in a script with or without the semicolon. Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> _______________________________________________ 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
