LiveCode Forums.

Code: Select all

on mouseUp
-- use a global variable to hold the connection ID so other scripts can use it
global gConnectionID


-- connect to the database
put revOpenDatabase("ODBC", "data source name", "database name", "userid", "password" ) 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