Updated or not?

[Davidmc555]

I have a simple ASP.net app that accesses an Access DB. Now, this query could go anywhere but I'm gonna try here.

Using an OleDB Connection and Command object, I'm called an update command using JET sql. No problems there, it does what it should.

The thing is I'd like to know if it actually updates or not to provide the user with a prompt if it doesn't.

conActiveObj = New OleDb.OleDbConnection

            conActiveObj.ConnectionString = ConfigurationSettings.AppSettings("OleDBConnection").Replace("fullpath", Server.MapPath("/"))
            conActiveObj.Open()

            strSQLQry = "UPDATE License As L SET L.licenseActivation = Now() WHERE(L.licenseClientID = " & txtClientID.Text & ") AND L.licenseCode = '" & txtLicenseKey.Text & "' AND L.licenseDateTime = (Select MAX(licenseDateTime) From License Where License.licenseClientID = L.licenseClientID AND License.licenseCode = L.LicenseCode);"

            cmdActive = New OleDb.OleDbCommand(strSQLQry, conActiveObj)
            cmdActive.ExecuteNonQuery()

Any ideas would be a great help.

 

[Davidmc555]

Not as difficult as I had thought actually.

ExecuteNonQuery() returns a number reflecting the number of affected rows. 0 therefore meaning that the statement had no effect on the table.

Hope this helps someone in the future.