Problem adding or updating rows to remote MySQL database

HCL Domino Domino Forum
1

Hello,

I seem to be stuck and need some assistance. Trying to update or add a row to a MySQL database. Can connect and read/get data fine. Just can’t seem to push data. Have retried with this simple script, but still no go. I thought maybe I wasn’t getting write access, but result.readonly returns “False”. That means it’s “not” read only, correct?

Any suggestions on what I’m missing here would be most appreciated.

Thanks,

Erik

Sub Initialize

Dim con As New odbcconnection

Dim qry As New odbcquery

Dim result As New odbcresultset

Dim number As Integer

number = "999"

On Error Goto errorhandler

Set qry.Connection = con

Set result.Query = qry

Msgbox result.readonly

con.ConnectTo("remote_db") ' real name replaced for example purposes...

qry.SQL = "SELECT * FROM caller_table"

result.execute

'result.nextrow   'tried adding next row, but no difference

result.addrow

Call result.SetValue("TELNBR",number)

Call result.SetValue("LAST_NAME","Smith")

result.UpdateRow

result.Close(DB_CLOSE)

con.Disconnect

Exit Sub

errorhandler:

Msgbox result.getextendederrormessage,,_

result.GetErrorMessage

Exit Sub

End Sub

2

Subject: Problem adding or updating rows to remote MySQL database

Oh, and I was working it with the variable “number” declared as a String, but switched to an Integer just to see if it made any difference. No luck.

3

Subject: Problem adding or updating rows to remote MySQL database

I am having the exact same problem. I can create a result set, update the result set (re-read it back in the script and the data changes), but NO update on the database!!

I do a result.setvalue(“nameoffield”,“string data”)

then do a result.updaterow (comes back OK)

then close and disconnect

NO updates on the MySQL database. Is this yet another undocumented problem??

I tried in Notes 6.5.3 and Domino 7 server AND Domino 7 client with a remote ODBC connection.