[fpc-pascal] How to force unique field values with TBufDataSet

[stdreamer]

On 27/04/2015 18:38 μμ, Michael Van Canneyt wrote:
>
>
> 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  -  fpc-pascal at lists.freepascal.org
>>> 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  -  fpc-pascal at lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>
much better thank you for the clarification.