TdxServerModeCustomDataSource.SQLAdapter Property

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

Declaration

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’.

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