Platforms to show: All Mac Windows Linux Cross-Platform

SQLConnectionMBS class

dim con as new SQLConnectionMBS

try
  
  // where is the library?
  con.SetFileOption con.kOptionLibraryMySQL, SpecialFolder.UserHome.Child("libmysqlclient.dylib")
  
  // connect to database
  // in this example it is Oracle,
  // but can also be Sybase, Informix, DB2
  // SQLServer, InterBase, SQLBase and ODBC
  
  dim server as string = "192.168.1.80:3306@test"
  
  con.Connect(server,"root","",SQLConnectionMBS.kMySQLClient)
  
  MsgBox "We are connected!"
  
  // Disconnect is optional
  // autodisconnect will ocur in destructor if needed
  con.Disconnect
  
  msgbox "We are disconnected!"
  
catch r as RuntimeException
  MsgBox r.message
  
  // SAConnection::Rollback()
  // can also throw an exception
  // (if a network error for example),
  // we will be ready
  try
    
    // on error rollback changes
    con.Rollback
    
  catch rr as runtimeexception
    MsgBox rr.message
  end try
end try

• event Working
• property AutoCommit as integer
• property Client as integer
• property IsolationLevel as integer
• property Option(name as string) as string
• method ClientVersion as integer
• method Commit
• method Connect(DBString as string, UserID as string, Password as string, client as integer = 0)
• method Disconnect
• method Error as Boolean
• method ErrorCode as Integer
• method ErrorMessage as string
• method isAlive as boolean
• method isConnected as boolean
• method NativeAPI as variant
• method Rollback
• method ServerVersion as integer
• method ServerVersionString as string
• method SetFileOption(name as string, file as folderitem)
• method SQLExecute(command as string, CommandType as integer = 0)
• method SQLExecuteMT(command as string, CommandType as integer = 0)
• method SQLSelect(command as string, CommandType as integer = 0) as string
• method SQLSelectAsRecordSet(command as string, CommandType as integer = 0) as RecordSet
• method SQLSelectAsRecordSetMT(command as string, CommandType as integer = 0) as RecordSet
• method SQLSelectMT(command as string, CommandType as integer = 0) as string
• const kOptionAPPNAME = "APPNAME"
• const kOptionLibrarySeparator = ":"
• const kOptionWSID = "WSID"

Isolation Levels

Values for autocommit property

The database client constants

Options to specify the library with SetFileOption

This class has no sub classes.

Some methods using this class:

• MySQLMBS.AffectedRows(Conn as SQLConnectionMBS) as UInt64
• MySQLMBS.Error(Conn as SQLConnectionMBS) as string
• MySQLMBS.ErrorNumber(Conn as SQLConnectionMBS) as UInt32
• MySQLMBS.FieldCount(Conn as SQLConnectionMBS) as UInt32
• MySQLMBS.Info(Conn as SQLConnectionMBS) as string
• MySQLMBS.InsertID(Conn as SQLConnectionMBS) as Int64
• MySQLMBS.SetSSL(Conn as SQLConnectionMBS, keyPath as string, CertificatePath as string, AuthorityPath as string, authorityFolderPath as string, Cipher as string)
• PostgreSQLAPIMBS.DB(conn as SQLConnectionMBS) as string
• PostgreSQLAPIMBS.ErrorMessage(conn as SQLConnectionMBS) as string
• PostgreSQLAPIMBS.Host(conn as SQLConnectionMBS) as string
• PostgreSQLAPIMBS.Options(conn as SQLConnectionMBS) as string
• PostgreSQLAPIMBS.Password(conn as SQLConnectionMBS) as string
• PostgreSQLAPIMBS.Port(conn as SQLConnectionMBS) as string
• PostgreSQLAPIMBS.TTY(conn as SQLConnectionMBS) as string
• PostgreSQLAPIMBS.User(conn as SQLConnectionMBS) as string
• SQLCommandMBS.Constructor(connection as SQLConnectionMBS, SQLCommand as String, CommandType as integer=0)
• SQLDatabaseMBS.GetConnection as SQLConnectionMBS
• SQLite3MBS.BackupInit(Dest as SQLConnectionMBS, DestName as String, Source as SQLConnectionMBS, SourceName as String) as SQLite3BackupMBS
• SQLite3MBS.ErrCode(Conn as SQLConnectionMBS) as integer
• SQLite3MBS.ErrMessage(Conn as SQLConnectionMBS) as string
• SQLite3MBS.LastInsertRowID(Conn as SQLConnectionMBS) as Int64

Some properties using for this class:

• SQLAPIMBS.Connection as SQLConnectionMBS
• SQLCommandMBS.Connection as SQLConnectionMBS

Some examples which use this class:

• /SQL/DB2 Connect
• /SQL/Firebird Connect
• /SQL/Informix Connect
• /SQL/Microsoft SQL Connect
• /SQL/Microsoft SQL via ODBC
• /SQL/MySQL Connect
• /SQL/MySQL ExecuteSQL
• /SQL/MySQL ExecuteSQL with Parameters
• /SQL/MySQL Fetch rows bulk
• /SQL/MySQL Fetch values
• /SQL/MySQL Update values
• /SQL/MySQL Write blob to file
• /SQL/ODBC Connect
• /SQL/Oracle Connect
• /SQL/PostgreSQL API
• /SQL/PostgreSQL Connect
• /SQL/PostgreSQL RecordCount
• /SQL/Reporting From A Database/Reports Example with MBS
• /SQL/SQL Exception Tests
• /SQL/SQLDatabaseMBS MSSQL Connect
• /SQL/SQLDatabaseMBS MySQL Connect

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

Links
MBS Real Studio Plugins

• Sitemap
• Feedback / Questions
• Links
• Kontakt / Impressum
• Contact us