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
