hair-pulling frustration

[Peter Haworth]

I just tried it under 7.0 and same result - no problems with or without the
semicolon.  There must be something else going on in Dr Hawkins code.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Thu, Nov 13, 2014 at 11:58 AM, Neil Roger <neil at livecode.com> wrote:

> Hi Richard,
>
> I've  attempted to replicate the semicolon issue without any success. This
> could be why we have not come accross it during testing in-house. The
> script that I tested with is-
>
> global gConnectionID
> on mouseUp
>    global gConnectionID
>    if gConnectionID is not a number then
>       answer error "Please connect to the database first."
>       exit to top
>    end if
>    put "Table1" into tTableName
>    put "SELECT * FROM " & tTableName into tSQL
>
>    put revDataFromQuery(,,gConnectionID,"SELECT * FROM Table1;") into
> tData
>
>    if item 1 of tData = "revdberr" then
>       answer error "There was a problem querying the database:" & cr &
> tData
>    else
>       put tData into field "Data"
>    end if
> end mouseUp
>
>
> Both the inclusion and exclusion of the semi-colon return data as
> expected. If possible, could you supply a stack for me to test with and I
> will happily look into this further.
>
> Kind Regards,
>
> Neil Roger
> --
> LiveCode Support Team ~ http://www.livecode.com
> --
>
>
>
>
>
>
>
> On 13/11/2014 19:09, Dr. Hawkins wrote:
>
>> revDataFromQuery(,,17,"SELECT * FROM vader_darth______001_dna;")
>> yields
>> Message execution error:
>> Error description: value: error executing expression
>> Hint: ")
>>
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>