LiveCode Forums.

Code: Select all

on mouseUp
     -- use a global variable to hold the connection ID so other scripts can use it
       global gConnectionID
      -- set up the connection parameters - edit these to suit your database
       put "p3nlmysql200plsk.secureserver.net:3303" into tDatabaseAddress
       put "someUser" into tDatabaseName
       put "someUser" into tDatabaseUser
       put "Password" into tDatabasePassword
       -- connect to the database
       put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult
       -- check if it worked and display an error message if it didn't
      -- & set the connection ID global
       if tResult is a number then
             put tResult into gConnectionID
            //answer info "Connected to the database." & cr & "Connection ID = " & gConnectionID
       else
      
             put empty into gConnectionID
             answer error "Unable to connect to the database:" & cr & tResult
       end if
end mouseUp