LiveCode Forums.

But it works for me
put field can also work too

@dave.kilroy you are right cos' their explanation helped me to achieved that
Look at d code that worked for me.
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 ...

I got it now...inserted successfully. Thank you all

@bangkok the idea worked but is not getting user input from the field rather is inserting the field name
put "tusernumber" into userNumber
put "tname" into userName
put "tsexstatus" into usex
put "tdepartment" into department
put "tschool" into uschool
put "tname" into dlevel
put "tuaddress ...

Please what could be wrong with this script? is not inserting fields from my form into the table even when everything seems alright.

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 ...