cDsn="myDSN_NAME" && DSN STORE SQLCONNECT('&cDsn','jojo','~lJ@123') TO lnConn IF lnConn < 0 MESSAGEBOX("Connection Failed!",0+16,"mySql",1500) Else = SQLSETPROP(lnConn, 'Transactions', 2) = SQLEXEC(lnConn, "INSERT INTO TABLE_NAME(FIELD1, FIELD2); Values(?memvar1,?memvar2)") = SQLCOMMIT(lnConn) = SQLDISCONNECT(lnConn) MESSAGEBOX("Insert Successful!",0+64,"",1500) lSuccess = .T. ENDIFHope it helps..