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 <n...@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ 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
