I was working with the following code:
** Send the SQL statement to the Oracle database
returnValue=sqlexec(gnOracleConnection, sqlString)

if returnValue=-1 then &&if sqlexec failed
errormessage = "The Oracle connection gnConnection value is " + str(gnOracleConnection) + chr(13)
errormessage = errormessage + "The error number should be " + str(error())+ chr(13)
errormessage = errormessage + "The error message should be " + message() + chr(13)
errormessage = errormessage + "The ticket number being updated was " + alltrim(RECORDNUM) + chr(13)
messagebox(errormessage)
return
endif

sqlcommit(gnOracleConnection)

where sqlstring is a SQL command and gnOracleConnection was earlier defined as STORE SQLCONNECT('dsn', 'username', 'password') ;
TO gnOracleConnection.

I commented out the line sqlcommit(gnOracleConnection) and the program still added the records to the database. What's the point of the sqlcommit?