Hi All, Added ixUnique type index with IndexDefs or AddIndex, set IndexName or IndexFieldNames. But no effect, I can add same field values without any error.

On Mon, 27 Apr 2015, Gabor Boros wrote: > Hi All, > > Added ixUnique type index with IndexDefs or AddIndex, set IndexName or > IndexFieldNames. But no effect, I can add same field values without > any error. To the best of my knowledge, this is meant to import actual server index definitions, not to enforce in local data. It would often be useless to do so: it may wel be that a value is unique locally (in memory), but is not unique when you save it in the DB, for instance when you load only part of the data in your dataset. Michael. _______________________________________________ fpc-pascal maillist - http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

On 27/04/2015 12:40 μμ, Michael Van Canneyt wrote: > > > On Mon, 27 Apr 2015, Gabor Boros wrote: > >> Hi All, >> >> Added ixUnique type index with IndexDefs or AddIndex, set IndexName or >> IndexFieldNames. But no effect, I can add same field values without >> any error. > > To the best of my knowledge, this is meant to import actual server index > definitions, not to enforce in local data. > > It would often be useless to do so: it may wel be that a value is unique > locally (in memory), but is not unique when you save it in the DB, for > instance when you load only part of the data in your dataset. > > Michael. > _______________________________________________ > fpc-pascal maillist - > http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal > > you are kidding right? Have you just removed all local/single user application as target audience for TBuffdataset or is it my lack of understanding?

On Mon, 27 Apr 2015, stdreamer wrote: > On 27/04/2015 12:40 μμ, Michael Van Canneyt wrote: >> >> >> On Mon, 27 Apr 2015, Gabor Boros wrote: >> >>> Hi All, >>> >>> Added ixUnique type index with IndexDefs or AddIndex, set IndexName or >>> IndexFieldNames. But no effect, I can add same field values without >>> any error. >> >> To the best of my knowledge, this is meant to import actual server index >> definitions, not to enforce in local data. >> >> It would often be useless to do so: it may wel be that a value is unique >> locally (in memory), but is not unique when you save it in the DB, for >> instance when you load only part of the data in your dataset. >> >> Michael. >> _______________________________________________ >> fpc-pascal maillist - >> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal >> >> > you are kidding right? Have you just removed all local/single user > application as target audience for TBuffdataset or is it my lack of > understanding? I am not kidding. The indexes work in the sense that they sort correctly, but the ixUnique is AFAIK not enforced. I am not sure that ixCaseInsensitive is observed. I have checked this, and ixUnique at least is not even used in bufdataset. All this does not mean we will not accept patches to implement this, but currently uniqueness certainly is not enforced. Michael. _______________________________________________ fpc-pascal maillist - http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal