Most voted "firedac" questions
Firedac is a Universal Data Access library for developing applications for multiple devices connected to corporate databases. With its powerful universal architecture, Firedac enables direct, native and high-speed access from Delphi and C++Builder to Interbase, Sqlite, Mysql, SQL Server, Oracle, Postgresql, DB2, SQL Anywhere, Advantage DB, Firebird, Access, Informix, Datasnap, among others.
Learn more…52 questions
Sort by count of
-
5
votes1
answer2169
viewsProblems with slowness Delphi and Firedac
I have an application developed in Delphi XE and a month ago I changed the whole persistence structure that used to use ADO for Firedac. In the compatibility of the new persistence component I used…
-
5
votes1
answer396
viewsMigration dbExpress to Firedac
I’m migrating a system dbExpress to the Firedac, the system is in three layers (multtier), changed the components on the server side of SQLConnection for FDConnection, and the SQLDataset for…
-
4
votes1
answer2075
viewsHow to use Tfdjsondatasets in Delphi XE4?
Explanation Today I was seeing an example called FireDACJSONReflect in the Samples folder of Delphi XE6 and I saw that it was very interesting how the server communicated with the client and I would…
-
4
votes0
answers330
viewsInform Tfdautoincfield field value using Fdquery
Hello, Utiliso Mysql and I am migrating my projects from Delphi 2007 + Zeos to Delphi Berlin + Firedac (big change eim) and due to some business rules, auto increment fields of Mysql can be informed…
firedacasked 7 years, 6 months ago Benjamim Mendes Junior 1,017 -
4
votes2
answers1858
viewsFiredac multithread (Simultaneous connections - REST server) DELPHI
Good morning Personal, I’d like to request some help from you, in case anyone can help I’m super grateful. Doubt would be reasonably simple, how to work with Multi Thread in Firedac? In other…
-
4
votes1
answer1556
viewsDifference between Transaction.Commit and Transaction.Commitretaining
Using Firedac technology, I want to know exactly the difference between Commit and CommitRetaining. I read in the official documentation of Firedac that Commitretaining keeps the transaction open.…
-
3
votes1
answer2204
viewsFiredac -How to use the same Fdquery in more than one bank?
I heard that the FD has to program for two different database managers using the same FDQuery, that is, could put the two SQL s of each bank in the same FDQuery... or something like that... Hold on…
-
3
votes1
answer834
viewsApplyupdates 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…
-
3
votes2
answers458
viewsFiredac: Getfieldnames without quotation marks
I’m recovering the table fields Firebird and Mysql for Firedac Connection via the command line GetFieldNames, however some fields of the list are returned with quotes. I have tried to insert the…
-
3
votes1
answer255
viewsAbort the execution of a long-term SQL
I have a very time consuming SQL (more than 10 minutes) to return the data. However, he is executed in a Thread and therefore the Mainthread continues to run normally. While SQL is running, the user…
-
3
votes3
answers6801
viewsFiredac Connection with Postgresql DLL Error
I’m with DLL error not found when making a connection to Postgresql using the Firedac component. Error: [Firedac][Phys][PG]-314. Cannot load vendor library [C: EXE libpq.dll]. Hint: check it is in…
-
3
votes2
answers304
viewsCreatedatabase Delphi VCL
How to create the database automatically if it does not exist, same in app from Delphi Android, but I want to do it with Delphi VCL. I want my application in the first run to automatically create…
-
3
votes2
answers727
viewsReduce Firebird memory consumption when closing Dataset
I have an app Delphi XE7 which rotates on a seat Firebird 2.5. When I open a FDTable with a 10,000 records for example, Firebird server memory consumption increases by about 1 MB. So far so good,…
-
3
votes2
answers251
viewsFdquery what risks to use variable instead of Parameter
I’m making a connection to search for data inside the bank on one condition IN(), but I had trouble implementing it between FDQuery and the Firebird. Analyzing the problem I realized that command…
-
2
votes1
answer262
viewsAbout Tadeventalert from the Firedac component suite. What is it and what is it for?
Continuing to wonder about components of FireDAC, component suite purchased by Embarcadero to the Delphi, would like to know about the TADEventAlert. What is the purpose of this component, and…
-
2
votes1
answer1384
viewsDelphi XE7/XE8 - Refresh in database (real-time update)
I have two interconnected systems, one saves a record in the database and another reads the saved record, currently I use a timer to refresh the database in the system it reads, so it takes every 5…
-
2
votes1
answer102
viewsSQL abstraction with Firedac
I would like to know how best to work with abstraction of SQL in a multi-bank system. For example: Firebird: SELECT SUBSTRING(nome FROM 5 FOR 8) FROM clientes Oracle: SELECT SUBSTR(nome,5,8) FROM…
-
2
votes2
answers263
viewsDisable editing of Firedac dataset without generating an exception
Suppose a FDQuery with a select simple be connected with a DBGrid. I want to prevent the user from making any edits to the registry. I know there’s a choice EnableDelete in the FDQuery, but if the…
-
2
votes0
answers1332
viewsHow to create Tdatasetfields in Tfdmemtable at runtime
With 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…
-
2
votes2
answers1468
viewsHow to use Firebird WITH LOCK with Delphi Firedac
I’m 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" with the "Firedac"? This…
-
2
votes0
answers28
viewsReturn field calculated by Firebird Generator (Firedac)
I have Tfdquerys created at runtime for the purpose of entering records into my database. Table: CREATE TABLE TABLETESTE ( ID INTEGER ); SET TERM ^ ; /* Trigger: TABLETESTE_BI */ CREATE OR ALTER…
-
1
votes1
answer308
viewsAbout the Tadcommand and Tadtableadapter components, what are they, what are they for?
In the components suite purchased by Embarcadero for the Delphi, the FireDAC, there are two components I would like to know about them. Are they the TADCommand and TADTableAdapter. What are, what…
-
1
votes0
answers312
viewsTfdsqlitebackup android Delphi xe7
I’m trying to do backup of my Android application, application made in Delphi. I am using the component TFDSQliteBackup with the following code, it executes and creates the file, but the file is…
-
1
votes2
answers2040
viewsFiredac Refresh or Refreshrecord
I’m going through an unusual situation with Firedac. I use Delphi 2009 + Firedac V8.0.5.3365 and only one component ADQuery without DataSetProvider and ClientDataSet. After the inclusion of a record…
-
1
votes2
answers2645
viewsMultiple transactions with Firedac?
I would like to work with multiple simultaneous transactions on Firedac, making decisions (rollbacks and commits) different for each one. Is it possible? Currently, I work as follows: try…
-
1
votes1
answer574
viewsInsufficient memory with Clientdataset.Savetofile
I need to generate a file XML of a table of 500,000 rows and 200 columns using ADQuery of FireDAC and TClientDataSet recording with ClientDataSet.SaveToFile(Arquivo). I need to record with the…
-
1
votes2
answers692
viewsHow to disable Autocommit in Firedac
How would it be to disable Autocommit type: FDTable1.AutoCommit := False; or FDconection.AutoCommit := False; I don’t think so.
-
1
votes1
answer601
viewsHow to synchronize auto increment keys between different databases in Firedac?
I am researching how the auto increment fields work in Firedac, using Delphi xE7 and managed to assemble an example of the documentation that synchronizes two master-details tables with the correct…
-
1
votes1
answer653
viewsProblem with Delphi 10.1 + Firedac (Autopost)
I have a Procedure simple to save in database. In it I also made a control cases the mandatory fields are not filled in making the system avoid recording wrong data or missing information. However…
-
1
votes2
answers749
viewsDelphi - how to treat delete in the master-Detail relationship?
I have two tables using Firedac Tfdtable and did the Master-Detail relationship between them which works well. In Forms I have two Dbgrids, one for each table , when deleting a record in Dbgrid…
-
1
votes0
answers276
viewsWhat are the advantages and disadvantages of working with Firedac
There’s been a lot of good talk about fireDac but what are the Perks and Disadvantages to use it? Which databases are most suited to this technology?…
-
1
votes1
answer200
viewsGet Tjsonstring value from Firemonkey (Delphi)
good afternoon! I have a problem and I’d like to see if you can help me. I have a Datasnap server, which is working normally. In it, I include and query in the database by mobile devices. In the…
-
1
votes1
answer1711
viewsFDQUERY at runtime
I’m trying to use the FDQuery only at runtime. I’ve done a lot of research and tried several changes, but they all end with Access Violetion, so it’s suspicious that the component isn’t being…
-
1
votes0
answers214
viewsHow to run more than one query in Delphi Seatle in Firedac’s Fdquery using oracle?
Using Sqlserver it is possible to run the following two queries within the same firedac Fdquery FDQuery.FetchOptions.AutoClose := False; FDQuery.sql.add('select * from tabela1');…
-
1
votes0
answers52
viewsNested Datasets with Fdquery Firedac
Hey, guys, everything okay? I need to ask a question, when using dbExpress, it was possible to make master detail with the clientDataSet using the Nested Dataset, where in the clientDataSet PAI,…
-
1
votes2
answers196
viewsFiredac only records when I close the connection with the bank
I wonder if anyone’s been through this problem. I use Firedac with Firebird in Rad Studio 10.2 Tokyo, but I have tried several ways to record the transaction, but the record does not persist in the…
-
0
votes0
answers697
views[Firedac][Dats]-16. Cannot process - no Parent. Constraint [Foreingnkeyconstraint]
I have a link master detail Using Delphi Mysql and Firedac (adquery) I had a screen with client/contact data, recorded perfectly smoothly master detail used as the example of the…
-
0
votes2
answers1258
viewsConnection between Mysql and Firedac closes the application when enabled
I have developed an application that uses Firedac to connect to Mysql. But when I try to open it on a station, at the time when the Connected := True, the application is closed, without returning…
-
0
votes2
answers963
viewsPass Ifddatasetreference (Firedac) to Clientdataset.Data
I have a Query of Firedac (Fdquery) and want to pass its result to a Clientdataset. Since Firedac works with Ifddatasetreference and the Clientdataset work with Olevariant, of the compatibility…
-
0
votes1
answer879
viewshow to use SQL Server Expressions/Functions in a Tfdquery filter in Delphi
I have the following situation, I need to check if the time of a given task is no longer filled in the system and for this by performing an SQL command in SQL Server 2014 works, as in the example…
-
0
votes1
answer276
viewsDatasnap with Firedac
In an application with Datasnap, I used Sqlconnection: procedure TForm1.Button1Click(Sender: TObject); var ConectaServidor : TUClasseServidorClient; begin ConectaServidor :=…
-
0
votes0
answers492
viewsHow to recover the id entered in the sqlserver database using Delphi datasnap
How to get the id that has just been inserted into the bank on the server side, use Delphi XE10.1 Sqlserver Bank and Firedac, I would like to take the id to use in the child table when it is master…
-
0
votes1
answer117
viewsSlow tfdquery.Append
Slow append. Tfdquery when applying value in a field with SGDB in the cloud, consumes 144 thousandths of seconds by changing the Tfdquery.Autocalcfields Property to false, this time reaches 071…
-
0
votes1
answer311
viewsHow to post a record of details in an Fdquery with the parent record in insert mode?
I’m using two FDQuery with master-detail relationship and found a problem: using property CachedUpdates and relating both FDQuery à um FDSchemaAdapter. Call "Insert / Append" in the Mestre and then…
-
0
votes2
answers799
viewsDelphi - Grid does not display all fields of the SQL statement
I’ve been racking my brain for two days and I can’t figure out the problem. I have an SQL (Tfdquery) statement written in the code that selects three fields from a table to display them in a Dbgrid.…
-
0
votes1
answer477
viewsMaster and Detail in Delphi, with Schemaadapter, only recorded the second time onwards
I am using Delphi 10.1, Firebird 2.5 with Firedac. I have 3 Fdquery, all with Cachedupdates = true, being 1 MASTER, and 2 Detail. In the bd, the FK points to the ID of the master table. In the…
-
0
votes1
answer50
viewsShould I use First after using Open in Firedac?
When I use Fdquery to perform a select that returns n records, I need to use the . First command after the . Open to make sure it stays on the first record? Example: QryAux3.Close; QryAux3.SQL.Text…
-
0
votes0
answers184
viewsProblems running Mysql function using Delphi Firedac 10.1
In a Mysql database I have a function (not Procedure) fully functional, I can access normally within heidisql. At Delphi, I’ll tell you what function ExecutarFuncaoSQL(sFuncao: string; aParams:…
-
0
votes1
answer417
viewsFiredac - Datasnap + Fdmemtable + fkInternalCalc
I’m facing problems with fields fkInternalCalc when migrating from TClientDataSet for TFDMemtable. We use these fields for data manipulation in memory, but they will not be persisted, this is very…
-
0
votes1
answer209
viewsFiredac problem (Delphi XE 10.2 and Access 2000)
I am using Delphi 10.2, and I am trying to display the list of tables of an Access database. My BD path is higher than 128 characters... Way of my comic: pathbd := "C: basedata.......... data.mdb"…