TdxServerModeCustomDataSource.SQLAdapter Property

Specifies the adapter to be used for generating database-specific SQL queries.

Declaration

delphi

property SQLAdapter: TdxServerModeCustomSQLAdapter read; write;

Property Value

Type
TdxServerModeCustomSQLAdapter

Remarks

When targeting a particular database with a server mode data source, you need to specify the SQL adapter to be used for generating database-specific SQL queries. Each database system has a corresponding database-specific SQL adapter (a TdxServerModeCustomSQLAdapter descendant). You can specify the data source’s SQL adapter via the SQLAdapter , SQLAdapterClassName, or SQLAdapterClass property. At design time, the SQLAdapter property provides a list of available SQL adapters, allowing you to select one by name. Adapter names are self-explanatory and include the database system name for reference.

The following table lists all the SQL adapters that are shipped with the ExpressDataController and the classes that correspond to them.

Target Database System

Adapter Name

Adapter Class

(SQLAdapterClass)

Adapter Class Name

(SQLAdapterClassName)

| | --- | --- | --- | --- | |

Advantage

Advantage Adapter

TdxServerModeAdvantageAdapter

‘TdxServerModeAdvantageAdapter’

| |

Firebird

Firebird Adapter

TdxServerModeFirebirdAdapter

‘TdxServerModeFirebirdAdapter’

| |

InterBase

InterBase Adapter

TdxServerModeInterBaseAdapter

‘TdxServerModeInterBaseAdapter’

| |

Microsoft Access

MSAccess Adapter

TdxServerModeMSAccessAdapter

‘TdxServerModeMSAccessAdapter’

| |

Microsoft SQL Server

MSSQL Adapter

TdxServerModeMSSQLAdapter

‘TdxServerModeMSSQLAdapter’

| |

MySQL

MySQL Adapter

TdxServerModeMySQLAdapter

‘TdxServerModeMySQLAdapter’

| |

Oracle

Oracle Adapter

TdxServerModeOracleAdapter

‘TdxServerModeOracleAdapter’

| |

PostgreSQL

PostgreSQL Adapter

TdxServerModePostgreSQLAdapter

‘TdxServerModePostgreSQLAdapter’

| |

SQLite

SQLite Adapter

TdxServerModeSQLiteAdapter

‘TdxServerModeSQLiteAdapter’

Setting the SQL adapter via the SQLAdapter , SQLAdapterClassName, or SQLAdapterClass property is required before making the server mode data source active.

The following code shows how to initialize a TdxServerModeDBXDataSource data source to access the Microsoft SQL Server table called ‘ServerModeGridTableDemo’.

delphi

dxServerModeDBXDataSource1.SQLAdapterClassName := 'TdxServerModeMSSQLAdapter';
dxServerModeDBXDataSource1.TableName := 'ServerModeGridTableDemo';
dxServerModeDBXDataSource1.Active := True;