MySQL Plugin for REALbasic

Introduction

The MySQL Plugin for REALbasic provides a MySQL driver for the REALbasic Database API. It fully supports the REALbasic Database API, including schema editing in the IDE*.

* The MySQL plugin presently does not support the Cursor.Update and Cursor.DeleteRecord methods. These are being investigated for a future version of the MySQL Plugin.

Requirements

Installation

  1. Ensure that there is a folder name Plugins inside the folder that contains your copy of REALbasic. If there isn't one, create one.
  • Move the MySQL Database plugin from the mySQL Database plugin folder into the Plugins folder.
  • Restart REALbasic.

    Known Issues

    The MySQL Database Plugin doesn't support the Cursor.Update and Cursor.Delete methods. Therefore, it necessary to use direct SQL statements with the Database.SQLExecute command to Update and Delete records from a MySQL database. This issue is being investigated for a future version of the MySQL Plugin.

    Version History

    1.1

    1.0.1

    1.0

    Usage

    The driver may be used in REALbasic in two different ways:

    1. Using the "Select MySQL Database" menu item, found in the Add Data Source menu in the File menu in the REALbasic IDE.
    2. Using the OpenMySQLDatabase function in your application.

    The "Select MySQL Database" menu item displays the following dialog:

    • The fields in this dialog take the following input:

    The OpenMySQLDatabase function takes the same input as arguments, and returns a REALbasic Database object:

    Function OpenMySQLDatabase(host as String, database as String, user as String, password as String) as Database

    MySQL Database Plugin is a product of Essence Software.

    Contact:

    Phone: +44 (0)1577 861917
    Fax: +44 (0)1577 861914
    Email: info@essencesw.com
    Support: support@essencesw.com

    58 Montgomery Street
    Kinross
    Scotland
    KY13 8EB