Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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;
See Also