Hi, I’m trying to edit and save a RowSet generated by SQLDatabaseMBS (as I did with xojo’s native MySQL plugin). When I try to use the Rowset.Save method,
I get this error: “Cannot query table named [table name] from SQL.”
Does anyone have any information on this? tnx.
This is the code that i use :
Sub Pressed()
Dim db As New SQLDatabaseMBS
db.DatabaseName="mysql:127.0.0.1,3306@attivita"
db.UserName="usertest"
db.Password="pswtest"
Dim f As FolderItem= New FolderItem("C:\Program Files\MySQL\MySQL Server 5.7\lib\libmysql.dll")
Call SQLGlobalsMBS.SetDllDirectory("C:\Program Files\MySQL\MySQL Server 5.7\lib")
db.Option("CLIENT_MULTI_STATEMENTS") = "true"
db.Option("CLIENT_MULTI_RESULTS") = "true"
db.Option("AutoCache") = "true"
db.SetFileOption SQLConnectionMBS.kOptionLibraryMySQL, f
Try
db.Connect
Catch err As RuntimeException
Exit Sub
End Try
Try
Dim rs As RowSet
rs=db.SelectSQL("select * from allegati limit 1 ")
rs.EditRow
rs.Column("note").Value="zazo"
rs.SaveRow
Catch err As RuntimeException
err=err
End Try
End Sub
