dexrow

Object TWOLODBC
Unit: WOLDBK04.
Descendant of TDBDataSet. One is about the representation, in object WOL, of a basic linking with ODBC (Open Data Base Connector) of the GUI in use.

Public Methods and Events:

constructor Create (AOwner: TWOLRoot); override;
destructor Destroy; override;

procedure ExecuteSQL (SQLText: String);
Method used to execute a SQL declaration. It must be used befour the data set is returned or when the set doesn't exist.

function GetFieldData (Field: TField; Buffer: Pointer): Boolean; override;
function CreateBlobStream (Field: TField; Mode: TBlobStreamMode): TStream; override;

Public properties and Events:

It activates

SQL: TStrings (For Reading and Writing)
Property that loads an SQL declaration. It does not have internal verification of the text syntax.
DatabaseName: string (For Reading and Writing)
Property that indicates the name of DSN (Data Source Name) to be accessed in the ODBC.

User: string (For Reading and Writing)
Property that indicates the name of the user in the DSN configured in the ODBC.

Password: string (For Reading and Writing)
Property that indicates the access password in the DSN of the ODBC.

Cacheable: Boolean (For Reading and Writing)
Property that indicates if there is going to be a cache for the data that is received by ODBC.. It must be on whenever there is a significant amount of registers.

UpdateTable: String (For Reading and Writing)
Property that indicates the table that must be brought up to date by the methods append and post when Cacheable is True. If the data set is relative to more than one table, it is safer to bring up to date directly through SQL declaration.

BeforeOpen
AfterOpen
BeforeClose
AfterClose
BeforeInsert
AfterInsert
BeforeEdit
AfterEdit

Labels: pascal, wolgui