Devart Forums

There are many features of the delphi version of the sdac components that make my life as a programmer easier than it was (such as filtersql, filters just to name a few).
How to use the FilterSQL feature in the sqlDirect.net components?
I'm new in the sqldirect.net world.
Thanks for help
EarlyBird

The SqlDataTable component does not include the FilterSQL property to change the WHERE clause of SELECT statement but you can easily modify your select command in the design time.

dotConnect for SQL Server includes an advanced design time support (SqlDataTable, DataSet Wizard, DataSet Manager), handy SQL execution monitoring (SqlMonitor), high performance, regular new builds with bug fixes and new functionality implementation, etc.

For more information, please refer to our online documentation: http://www.devart.com/dotconnect/sqlserver/docs/.

Thanks for response.
i know the advanced design time support.
(I like all your components)
In Delphi i use FilterSQL support very often at runtime.
This makes my life much more easy.
Now i miss this feature in the SqlDataTable component.

My question is:
What is the best way to change the where clause of select Statment at runtime?

Please reassign the whole select statement via the sqlDataTable.SelectCommand.CommandText property.

are there any plans to implement such features.
which features you plan in next releases?
Is there a roadmap?

EarlyBird wrote:are there any plans to implement such features.

TMSTable (SDAC) and SQLDataTable (dotConnect for SQL Server) are implemented using a little bit different approaches. For example, usage of FilterSQL with SQLDataTable will lead to additional parsings of the SELECT query and, as a result, decreasing performance.

EarlyBird wrote:which features you plan in next releases?

Please post here the features you are interested in, and we will investigate the possibility of its implementation in dotConnect for SQL Server.