Questions tagged as 'firedac'

Tagged questions
1
answer

ApplyUpdates on REST with Firedac

I'm doing a project that uses a REST server with FireDac . I use a Generic function to give my select but when I try to give my ApplyUpdates it does not give any error but the data is not reflected in the DB. My Applyupda...
asked by 01.07.2015 / 15:35
0
answers

Abort execution of a long-running SQL

I have a very time-consuming SQL (more than 10 minutes) to return the data. However, it runs on a Thread and therefore the MainThread continues to run normally. While SQL is running, the user can shut down the system, and that's where the pr...
asked by 09.05.2017 / 20:42
1
answer

Delphi XE7 / XE8 - Refresh in database (real-time update)

I have two systems interconnected, one saves a record in the database and another reads the saved record, I currently use a timer to refresh the bank on the system that reads, so it picks up every 5 seconds that was saved by But I do not think i...
asked by 07.05.2015 / 18:50
2
answers

Disable FireDAC dataset editing without generating exception

Suppose a FDQuery with a select simple is connected with a DBGrid . I want to prevent the user from doing any editing in the registry. I know there is a EnableDelete option in FDQuery , but if the user tries to...
asked by 20.09.2016 / 20:12
2
answers

How to use Firebird WITH LOCK with Delphi FireDac

I am trying to block a table on my system in order to prevent other users from entering the system when the procedure is running, how can I do this using the "WITH LOCK" / strong> with "FireDac" ? Does this eating lock the table for writi...
asked by 16.11.2017 / 19:15
1
answer

SQL Abstraction with FireDAC

I would like to know how best to work with SQL abstraction in a multi-banking system. For example: Firebird : SELECT SUBSTRING(nome FROM 5 FOR 8) FROM clientes Oracle : SELECT SUBSTR(nome,5,8) FROM clientes How to make the ap...
asked by 23.02.2017 / 18:01
1
answer

About the TADEventAlert of the FireDAC component suite. What is it and what is it for?

Continuing to wonder about components of FireDAC , component suite acquired by Embarcadero for Delphi , I'd like to know about the TADEventAlert component. What is the purpose of this component, what is the purpose and p...
asked by 10.05.2014 / 02:25
2
answers

Reduce FireBird memory consumption when closing Dataset

I have a Delphi XE7 application that runs on a FireBird 2.5 . When I open a FDTable with a 10,000 records for example, the memory consumption of the FireBird server increases by
asked by 08.06.2018 / 14:48
1
answer

Insufficient memory with ClientDataSet.SaveToFile

I need to generate a XML file of a table of 500,000 rows and 200 columns using ADQuery of FireDAC and TClientDataSet saving with ClientDataSet.SaveToFile(Arquivo). I need to write with ClientDataSet to rem...
asked by 11.03.2016 / 18:54
0
answers

How to create TDataSetFields, in TFDMemTable, at runtime

With the ClientDataSet it was possible to bring a TDataSetField field with another data structure (another table) internally. This was done automatically by TDataSetProvider. I'm migrating to FireDac and TFDMemTable, but unfortunately it does...
asked by 11.08.2017 / 21:15