Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement