LiveCode Forums.

Code: Select all

on Query
   -- check the global connection ID to make sure we have a database connection
   
   if gConnectionID is not a number then
      answer error "You're not connected"
      exit to top
   end if
   	
   -- construct the SQL (this selects all the data from the specified table) 
   put "Persons" into tTableName	-- set this to the name of a table in your database
   put "SELECT * FROM " & tTableName & " ORDER BY HighScore DESC, Username ASC" into tSQL
   	
   -- query the database
   put revDataFromQuery(tab, cr, gConnectionID, tSQL) into tData
   	
   -- check the result and display the data or an error message
   if item 1 of tData = "revdberr" then
      answer error "Can't connect:" & cr & tData
   else
      put tData into field "ProvaData"
   end if
end Query

Code: Select all

...
## This will not work, since that is NOT ITEM 1!
  ## if item 1 of tData = "revdberr" then
  ## use this:
  if tData begins with "revdberr" then
      answer error "Can't connect:" & cr & tData
   else
  ...