FilterSql features

EarlyBird · Post by **EarlyBird** » Fri 27 May 2011 06:13

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

Shalex · Post by **Shalex** » Tue 31 May 2011 13:13

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

EarlyBird · Post by **EarlyBird** » Wed 01 Jun 2011 07:07

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?

Shalex · Post by **Shalex** » Wed 01 Jun 2011 08:58

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

EarlyBird · Post by **EarlyBird** » Fri 03 Jun 2011 13:11

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

Shalex · Post by **Shalex** » Mon 06 Jun 2011 08:09

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.