Roger Cigol

I am using DUnit based unit tests to devlop FireDAC VCL C++ code (Sydney 10.4.1). I am using FDMemTables to create test instances of database tables to unit test FDQuery operations etc. So I want the FDMemTable to accurately reflect the structure of the eventual end database table(s). Some (most) of these tables need a primary key, often consisting of several fields. I can find how to add indexes to FDMemTables { using TFDIndex *NewIndex = MyFDMemTable->Indexes->Add() } but I can't find a way to add a primary key to the FDMemTable. Question ; can anyone show me C++ code (or Delphi code is fine too) how to add a primary key to a newly created FDMemTable.

Thank you. I did realise that my FDMemTable is acting as a mock. But what is the indice ?

Hi Uwe - Just spotted that you are different person to Anders. sorry to be so rude (and confusing?) with my last post !

Hi Anders, Your first post pointed me in the right direction. I am now getting the expected exception when I deliberately try to post a "duplicate" entry to the table. - great ! really appreciate this. My plan was to do a little more testing (and test writing) and then click on the "thanks" button. But your second post has got me intrigued. I don't know what a query mock indice is. The goal is to have a close match "as is reasonably practical". But since I don't understand/recognise your term I am not qualified to make the judgement as to it being "reasonably practical". If you do have a spare moment to explain it would be really appreciated and valuable to me....