ZmemTable how to create composite key and find them?
lazarus / 16-Databases

----------------------------------------------------------------------
hamacker · 2023-07-21 14:19

Hi All,

I´am trying to use zMemtable as Delphi Client Dataset, but it´s my
first time with Zeos 8 Memtable, how Can I Create a dataset in runtime
memory, create index and find key fields? I create this sample, but
something is wrong, can you help me? Follow:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i // samplezM
emTable1.FilterOptions:=[foCaseInsensitive];zMemTable1.FieldDefs.Clear
;zMemTable1.FieldDefs.Add('status', ftString, 3,
False);zMemTable1.FieldDefs.Add('seq', ftInteger, 0,
False);zMemTable1.FieldDefs.Add('filename', ftString, 1024,
False);zMemTable1.FieldDefs.Add('filepath', ftString, 1024,
False);//zMemTable1.CreateDataSet; // not exists CreateDataSet ?zMemTa
ble1.Active:=true;zMemTable1.IndexFieldNames:='filename;filepath'; //
is it right to use two fields?if not zMemTable1.FindKey(['arq.exe',
'c:\temp']) then // there is no FindKey?begin  // not found ...end; In
this sample does not exists zMemTable1.CreateDataSet, really not
necessary?
In this sample I use zMemTable1.IndexFieldNames:='filename;filepath'
to create a index with two fields(composite key), is it right?
in this example i try to lookup composite key according to
IndexFieldNames method zMemTable1.FindKey(['arq.exe', 'c:\temp']), but
there is not FindKey method, how to find them?

Any help will be welcome.