LiveCode Forums.

Code: Select all

global gConID

on mouseUp
   -- clear combo
   put "" into button "cboFilter"
   -- connect to database
   connectToDb
   --sql
   put "SELECT * FROM tbTypes" into tQuery
   -- execute sql
   put revDataFromQuery(,,gConID,tQuery) into tRecords
   -- handle error
   if tRecords begins with "revdberr" then 
      answer error "There was a problem accessing the people database: " & tRecords
      closeDB gConID
      exit to top
   end if
   -- close db
   closeDB gConID  
   -- insert datas in combo
   put tRecords into button "cboFilter"
end mouseUp