Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: RE: XE6 - TFDTable Filter issue



Permlink Replies: 2 - Last Post: Oct 20, 2016 10:41 AM Last Post By: Deivis Átila
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
RE: XE6 - TFDTable Filter issue
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 26, 2015 1:03 AM
--
With best regards,
Dmitry Arefiev / FireDAC Architect
Norbert Meier

Posts: 19
Registered: 11/26/01
Re: RE: XE6 - TFDTable Filter issue
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 29, 2015 12:06 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
FYI:

The filter string for TFDTable must be (with {fn } for substring):

TFDTable.Filter := ({fn SUBSTRING( {id COL1}, 6, 1)} = {s 4} )

The filter string for TFDQuery can be: (without {fn } for substring) -- This doesn't work for TFDTable!

TFDQuery.Filter := (SUBSTRING( {id TYP}, 6, 1) = {s 4})

Thanks
Norbert
Deivis Átila

Posts: 3
Registered: 7/17/10
Re: RE: XE6 - TFDTable Filter issue
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 20, 2016 10:41 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Dmitry Arefiev wrote:
--
With best regards,
Dmitry Arefiev / FireDAC Architect

Good afternoon, how to apply this patch? What tool I use to apply?
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02