KbmMemTable Unique index

[lettumika]

Hi,

I’d like to create unique index for kbmmemtable.

I have tried CustomerMemTable.IndexFieldNames := ‘CustID:U’

or
CustomerMemTable.IndexDefs.Add(CustId’,’CustId’,[ixPrimary,ixUnique]);
It works so that insert fails but there is no error generated . also no error is generated when index is modified to unique (only other non unique record disappears)

What i’m missing here?

Thanks

MIka

[kimbomadsen]

kbmMemTable will raise EMemTableDupKey exception in case a unique index violation is about to happen. Are you sure you have not trapped the error, or in your IDE ignored showing the exception?

[lettumika]

I have been working with other subjects but returned to this now.
I found the following:
IndexFieldNames := ‘Field:U’ doesn’t work

but IndexDefs.Add(CustId’,’CustId’,[ixPrimary,ixUnique]); works when done if table if opened after that (of course)

 

• This reply was modified 4 years, 6 months ago by lettumika.

[Author]

Posts