dexrow

TWOLMySQL object
Unit: WOLDBK03.
Descendant of TDBDataSet. An object that represents a MySQL database.

Public Methods and Events:

constructor Create (AOwner: TWOLRoot); override;
destructor Destroy; override;
function GetFieldData (Field: TField; Buffer: Pointer): Boolean; override;
function CreateBlobStream (Field: TField; Mode: TBlobStreamMode): TStream; override;

procedure ExecuteSQL;
Method used to execute an SQL database directly. It must be used when the dataset isn't of interest or when there will be no generated dataset.

Public properties and Events:

It activates
SQL: TStrings (For Reading and Writing)
Property that loads in the text of an SQL declaration. It must be noted that it does not have internal verification of the text syntax.

DatabaseName: string (For Reading and Writing)
Property that points to the name of the data base to be accessed.

Host: string (For Reading and Writing)
Property that indicates the name of the computer where the MySQL server is.

Port: Integer (For Reading and Writing)
Property that indicates the access door of the mySQL data base.

User: string (For Reading and Writing)
Property that indicates the user name registered in the MySQL server.

Password: string (For Reading and Writing)
Property that indicates the password used to open the data base indicated as the MySQL server.

Cacheable: Boolean (For Reading and Writing)
Property that it indicates that the database has a cache or not.. If the number of registers of the table or set will be expressiva, must point True with respect to this property.

UpdateTable: String (For Reading and Writing)
Property that indicates the table where the fields are brought up to date. When the cache object is brought up do date with the data in append or post it will look to this table to get the date the information. If it is more than a table of declaration in SQL it is safer to use SQL directly to bring up the data.

BeforeOpen
AfterOpen
BeforeClose
AfterClose
BeforeInsert
AfterInsert
BeforeEdit
AfterEdit
BeforePost
AfterPost
BeforeCancel
AfterCancel
BeforeDelete
AfterDelete
BeforeScroll
AfterScroll
OnDeleteError
OnEditError

Labels: pascal, wolgui