Stack Overflow
Stack Overflow

Questions tagged [firedac]

A Delphi/C++Builder data access library, sold by Embarcadero, for developing applications for multiple devices, connected to enterprise databases

FireDAC is a Universal Data Access library for developing applications for multiple devices, connected to enterprise databases. With its powerful universal architecture, FireDAC enables native high-speed direct access from Delphi and C++Builder to InterBase, SQLite, MySQL, SQL Server, Oracle, PostgreSQL, DB2, SQL Anywhere, Advantage DB, Firebird, Access, Informix, DataSnap and more.

See the FireDAC home page for more info

803 questions
4
votes
0 answers

Why TFDMemTable is slower than TClientDataSet?

The Embarcadero official said "TFDMemTable is faster than TClientDataSet",But I Make an little speed test and TFDMemtable slower than TClientDataset (Delphi XE7). { Test 30k records TClientDataSet TFDMemTable Append 1482ms …
Natural
  • 51
  • 1
  • 4
4
votes
1 answer

Delphi EMS FireDAC: How to pass parameter from client to server using EMS?

I am working on the simple client server application using EMS (i.e: for future iOS application) in Delphi. On the client unit, I have EMSProvider and EMSFireDACClient which fetches data from a Database (MSSQL) through a Datasource. On the server…
A_R
  • 109
  • 2
  • 12
4
votes
5 answers

Working with parameters Delphi XE7 Firedac

Any assistance here would be great. I am trying to use parameters to dynamically change 'ORDER BY' Below is the code I have tried but despite following the documentation I still get an error '[FIREDAC][PHYS][MYSQL] You have an error in your SQL…
Eishman
  • 125
  • 2
  • 3
  • 9
4
votes
1 answer

Get database info by Firedac replacement for TIBDatabaseInfo from IBX

i need to migrate IBX (Interbase/Firebird) connectivity to Firedac but how can i get specific vendor info like we got by TIBDatabaseInfo component by Firedac? I am interest of counters BackoutCount, DeleteCount, ExpungeCount ... how to retrive this…
Livius
  • 958
  • 1
  • 6
  • 19
4
votes
1 answer

AnyDac aka FireDac cannot generate update query

I was using UniDac for a long time now and decided to move on to FireDac as it has good Asynch methods after moving on i saw that none of my data editing works anymore it gives me an error: [FireDAC][Phys]-330. Cannot generate update query. Update…
AirWolf
  • 597
  • 7
  • 27
4
votes
1 answer

Delphi: FireDac Connection blocking the application

I'm working to an application with a login form at the start-up. Until user is writing the login data, I would like to connect discreetly to the SQL server. The problem is that, when I have a slow connection or a wrong path to the server, the…
REALSOFO
  • 852
  • 9
  • 37
4
votes
2 answers

Pass long Unicode strings to FireDac TADQuery parameter

I was using AsWideString to pass Unicode string to TADQuery parameter. ADQuery.Params.ParamByName('MyFld').AsWideString But when string becomes too long I got error: [MyFld]. Max len = [8002], actual len = [10522] Then I decided to use AsMemo…
vico
  • 17,051
  • 45
  • 159
  • 315
4
votes
1 answer

Creating a database in Firebird using FireDac (Delphi)

I recently changed from AnyDac to FireDac (8.0.5.3365). We're running Delphi 2006. When I was using the AnyDac version of this component I could create a new database by doing the following.. Setup my connection fConnection.LoginPrompt :=…
cjmarques
  • 632
  • 1
  • 7
  • 17
4
votes
3 answers

How to use a FireDAC TFDConnection to iterate through tables, fields and field definitions

I am teaching myself to use SQLite and FireDAC together in Delphi. I am not very experienced with the latest incarnations of databases and tools so after writing a very simple application to display a single table from an SQLite file, I decided that…
Brian Frost
  • 13,334
  • 11
  • 80
  • 154
3
votes
1 answer

RAD Server Delphi - using savetostream und loadfromstream does not work because of mutated vowels after Json conversion

I try to exchange Data via RadServer IIS Package and Delphi Client with EMSEndpoint. What I try looks simple to me but I can't get it done now. In the Package there is a TFDConnection pointing to a MSSql Server. TFDQuery is connected with that…
fisi-pjm
  • 378
  • 2
  • 16
3
votes
1 answer

Firedac Passing Column name as Parameter

In Delphi Firedac I have a very long query. I would like to reuse it just changing the name of a column via parameter like this select f1, f2 from t1 where id = :par1 and :colimn_name = :value_name Passing the :column_name parameter the reult query…
Franz Andreani
  • 77
  • 10
3
votes
1 answer

Why does [FireDAC][Phys][ODBC]-345 say that Max len is 256 characters?

In question How to properly access a VARCHAR(MAX) parameter value of a FireDAC dataset when getting "data too large for variable" error? the error message says Max len = [8002] for a VARCHAR(MAX) field. In my case however, using a MS SQL 2017…
mjn
  • 36,362
  • 28
  • 176
  • 378
3
votes
0 answers

FIREDAC TFDparams - can't send emoji

I'm trying to save text with emoji (like "hello world") to MYSQL Everything goes fine when I just use it without FDparams: FDQuery.SQL.text:='update USER set status="hello world"' But if I try to use TFDparams, the troubles begin: (A)…
fewrandom
  • 312
  • 1
  • 9
3
votes
1 answer

Is there a way to iterate over FireDAC's TFDParams using Delphi's for .. in .. do?

With Delphi 10.2 (Tokyo), I just want to do something as simple as: function ShowFinalSQL(const qry: TFDQuery): String; var cSQL: String; oParam: TFDParam; begin cSQL := qry.SQL.Text; for oParam in qry.Params do cSQL :=…
Fábio Amorim
  • 103
  • 8
3
votes
0 answers

Delphi TFDMemTable, CloneCursor and source table out of sync, unless Refresh is called

the code i'm working on makes heavy usage of TFDMemTables, and clones of those tables using CloneCursor. Sometimes, under specific conditions which I am unable to identify, the source table and its clone become out of sync: the data between them may…
Khorkhe
  • 1,024
  • 1
  • 11
  • 26
1 2 3
…
53 54