Filter with LIKE comparisation

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply

Filter with LIKE comparisation

Post by tonisanta » Tue 15 Mar 2005 14:44

Hi SDAC-users,
how you probably noted the [field] like 'string%' doesn't work when specified in the TMsQuery.Filter-property. Changing the string to 'string*' it works as aspected.
What do you think: Should the component replace the internal fFilter-string from 'string%' to 'string*' ? Please vote!
best regards

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Wed 16 Mar 2005 09:31

From our point of view this modification can cause problems at users who use % as an ordinary symbol.

To support compatibility with previous SDAC versions we are not planning to change this functionality.

Post Reply