Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

MySQLMBS.AffectedRows(Conn as SQLConnectionMBS) as UInt64
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 12.4 Yes Yes Yes Yes No
Function: Queries the number of affected rows in the last statement.
Notes:
see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-affected-rows.html

Feedback, Comments & Corrections

MySQLMBS.Error(Conn as SQLConnectionMBS) as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 12.4 Yes Yes Yes Yes No
Function: Queries the last error text.
Notes:
see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-error.html

Feedback, Comments & Corrections

MySQLMBS.ErrorNumber(Conn as SQLConnectionMBS) as UInt32
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 12.4 Yes Yes Yes Yes No
Function: Queries the last error code.
Notes:
see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-errno.html

Feedback, Comments & Corrections

MySQLMBS.FieldCount(Conn as SQLConnectionMBS) as UInt32
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 12.4 Yes Yes Yes Yes No
Function: Returns the number of columns for the most recent query on the connection.
Notes:
see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-field-count.html

Feedback, Comments & Corrections

MySQLMBS.Info(Conn as SQLConnectionMBS) as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 12.4 Yes Yes Yes Yes No
Function: Retrieves an info string providing information about the most recently executed statement.
Notes:
see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-info.html

Feedback, Comments & Corrections

MySQLMBS.InsertID(Conn as SQLConnectionMBS) as Int64
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 12.4 Yes Yes Yes Yes No
Function: Returns the last auto increment value from last insert command.
Notes:
see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-insert-id.html

Feedback, Comments & Corrections

MySQLMBS.NumberOfRows(cmd as SQLCommandMBS) as UInt64
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 12.5 Yes Yes Yes Yes No
Function: Queries number of records in a command.

Feedback, Comments & Corrections

MySQLMBS.SetSSL(Conn as SQLConnectionMBS, keyPath as string, CertificatePath as string, AuthorityPath as string, authorityFolderPath as string, Cipher as string)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 12.5 Yes Yes Yes Yes No
Function: Sets SSL connection parameters.
Notes:
Calls mysql_ssl_set internally.
Used for establishing secure connections using SSL. It must be called before Connect(). It does nothing unless SSL support is enabled in the client library.

keyPath is the path name to the key file.
CertificatePath is the path name to the certificate file.
AuthorityPath is the path name to the certificate authority file.
authorityFolderPath is the path name to a directory that contains trusted SSL CA certificates in PEM format.
Cipher is a list of permissible ciphers to use for SSL encryption.

Any unused SSL parameters may be given as empty string.
For paths, please use folderitem.UnixPathMBS and not folderitem.ShellPath.

Please switch to using the following options on the connection:

MYSQL_SSL_KEY
MYSQL_SSL_CERT
MYSQL_SSL_CA
MYSQL_SSL_CAPATH
MYSQL_SSL_CIPHER

They should be specified before the connection is made.
e.g.

db.Option("MYSQL_SSL_CIPHER") = "DHE-RSA-AES256-SHA"

Allows to specify MySQL SSL parameters that will be used with mysql_ssl_set. MySQL API method called only when at least one parameter specified. See MySQL documentation for more information about these options.

Feedback, Comments & Corrections

The items on this page are in the following plugins: MBS SQL Plugin.




Links
MBS Xojo Plugins