hair-pulling frustration

[Peter Haworth]

On Fri, Nov 14, 2014 at 9:21 AM, Peter Haworth <pete at 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>