Questions tagged [fdmemtable]

22 questions
0
votes
0 answers

FDMemTable Loses FieldDefs information when there is AutoInc Field in Delphi

I am creating a memory table TFDMemTable for a delphi form, and define the fields under FieldDefs. After I am done with the definition of the fields manually, I go to the Fields Editor to add the fields that I just defined. Everything works perfect…
0
votes
0 answers

Firedac - Datasnap + FDMemtable + fkInternalCalc

I have had some problems with these fields fkInternalCalc to migrate from TClientDataSet to TFDMemtable. We use these fields to manipulate data in memory time, but these fields mustn't be persisted. I mean, these fields "fkInternalCalc" are very…
rbazzan
  • 1
  • 1
0
votes
2 answers

TFDMemTable lost/clearing data after filtering

I have created a FDMemTable with following structure: Cds_NaMenu := TFDMemTable.Create(nil); Cds_NaMenu.FieldDefs.Add('ID', ftInteger); Cds_NaMenu.FieldDefs.Add('MN_TELA_CODIGO', ftInteger); Cds_NaMenu.FieldDefs.Add('MN_MENU_PESQUISA', ftString,…
0
votes
2 answers

Adding a new Field to FDMemTable when loading an existing data

I'm using TFDMemTable, i have created a dataset and populated my table with data and then used FDMemTable.saveToFile to save my data. Now here is the question, how can i add a new Field to this already saved data and fill all records with a default…
ali ahmadi
  • 179
  • 3
  • 20
0
votes
1 answer

How do I query number of files using Delphi firedac

I am trying to gather data from 3-5 files and query select average, stddev and group by I tried to make FdMemTable and put all data in one memtable. But I'm stuck from there. Are there any way to query Memtable or are there way to do query multi…
Amber
  • 1
  • 2
0
votes
2 answers

Delphi - Loading FDMEMTable

Sorry, not simple for a new Delphi'er In the code below, how do I move the results to a fdmemtable? • Do I have to loop-add each record or can the memtable just be set equal to the recordset using a function/procedure? • Or, can the results be sent…
OneFiveOne
  • 1
  • 1
  • 3
-3
votes
1 answer

Writing to a text file from a TFDMemTable

I need to write the contents of a TFDMemTable to a text file for later import into Excel. Is there a way to do this?
Ashley
  • 43
  • 9
1
2