Jump to content
TimStroobandt

Firedac Indexes Distinct

Recommended Posts

Hi,

 

I have an TFDQuery on which I defined a few indexes which have the "Distinct" property set to enabled.

When I set the index to selected, my dataset is always limited to 1 row, even though there are multiple distinct values in the result set.

 

One thing to mention is that the fields are InternalCalc fields.

Is this a bug or a limitation on InternalCalc fields?

 

Thx,

Tim

Share this post


Link to post
2 minutes ago, TimStroobandt said:

I defined a few indexes which have the "Distinct" property set to enabled

Try with one field at the time. <o>

Share this post


Link to post

I had only 1 index selected at any one time.  I have now removed all other indexes, so only 1 remains.

I still have the same issue

Share this post


Link to post

Please report that to quality.embarcadero.com and provide simple test application to reproduce the issue.

Without details / code hard to say anything ...

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×