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
5
votes
1 answer

To check if a query returns more Fields than when you created it and defined its persistent fields

When you have a select * from XXX query eventually you can get more fields than you expected, do you know if there is a way to check if new fields have been added since you created that query and defined its persistent fields ?. Normally you can…
Marc Guillot
  • 6,090
  • 1
  • 15
  • 42
5
votes
1 answer

Adding/changing sql metadata with firedac

Is there a way to add or change constraints (like primary keys, foreign keys, indexes, etc.) to an sql database with the TFDMetaInfoQuery from delphi firedac tools or the only thing I can do is extracting such information ? something like :…
Viktor Anastasov
  • 1,093
  • 3
  • 17
  • 33
5
votes
2 answers

FireDAC - Show SQL after Macro Expantion

I am trying to use Macros in FireDAC to Preprocess my SQL Queries. I have a TADQuery object on a Data Module with the SQL set to something like: Select * from MyTable join OtherTable on MyTable.Key = OtherTable.Key &Where Then in my code I do…
Mark Elder
  • 3,987
  • 1
  • 31
  • 47
5
votes
6 answers

Delphi XE5 FireDAC Error: Cannot load vendor library [libmysql.dll or libmysqld.dll]

I'm using Delphi XE5 on Windows 7 64bit and just trying FireDAC component. I'm using one TFDConnection component to connect to local MySQL database (v5.6.15). I already put the libmysql.dll (32bit v5.6.15) into my Project folder, the EXE folder and…
aurallion
  • 149
  • 1
  • 1
  • 6
4
votes
1 answer

Delphi: is DBexpress faster than Firedac

I'm running a Mysql server on my network (Mariadb 10.3.24), and have made a performance test with dbexpress and firedac on the same data, same machine and with no other users on the database. I'm using Delphi 10.1 and made no changes to the…
Ib Elfving
  • 87
  • 1
  • 3
4
votes
1 answer

FireDAC Add new field to existing SQL table

I am trying to create a new field in a FireDAC-compatible database with this PROCEDURE: PROCEDURE CreateField(Connection : TFDConnection ; CONST TableName : STRING; F : TFieldDefinition); VAR Table : TFDTable; BEGIN …
HeartWare
  • 7,464
  • 2
  • 26
  • 30
4
votes
0 answers

RxLib for Delphi 10.4 with FireDAC?

I wish to migrate a huge Delphi 5 code using RXlib BDE Data-Aware controls to latest Delphi 10.4 Sydney with FireDAC. I wonder if there anywhere someone who already went through it and migrated RXlib version using BDE to FireDAC?
Oren Aviram
  • 41
  • 3
4
votes
1 answer

Cannot load sqlite libraries in Android with Delphi 10.4

With Delphi 10.4 I get an error in my Android App (same error for both 32bit and 64bit). [FireDAC][Phys][SQLite]-314. Cannot load vendor library [libsqlite.so or libdb_sql.so]. Hint: check it is in the PATH or application EXE directories, and has…
Ole Mortensen
  • 105
  • 5
4
votes
2 answers

How to enable wirecompression on Firebird 3.0

I work with Firebird and Delphi, I want to implement access via internet with wirecompression; But I am unable to activate it. I have followed the steps inside this document for the new parameter(one of the few I was able to find) How to enable…
gasaluy
  • 41
  • 2
4
votes
2 answers

How to call the refreshing of data-aware (live-binding) component in FireMonkey?

I have a TListView linked in LiveBindings with a TFDMemTable. I load data in the FDMemTable using LoadFromFile (I have for example 20 record). When I delete a record from the FDMemTable, the RecordCount is decreased but the TListView is not…
Alain V
  • 311
  • 3
  • 17
4
votes
1 answer

why I can not open my sqlite database from firedac?

I can open my encrypted sqlite database with sqlite maestro application but I can not with fiedac I get this error [FireDAC][Phys][SQLite] ERROR: Cipher: Invalid password is specified or DB is corrupted Here is my data module unit: object DM:…
zac
  • 4,495
  • 15
  • 62
  • 127
4
votes
2 answers

How to query Firebird SQL Dialect

I'm trying to query the SQL dialect of a Firebird database (using the embedded driver): procedure TFrmFireDACEmbed.BtnGetDBDialectClick(Sender: TObject); var lFDConnection : TFDConnection; lDriverLink : TFDPhysFBDriverLink; l …
Jan Doggen
  • 8,799
  • 13
  • 70
  • 144
4
votes
0 answers

Unexpected behaviour with FireDAC Master-Detail relationships

I face a problem with FireDAC Master-Detail relationships. FireDAC has two modes for M/D relationships : Parameter-Based and Range-Based http://docwiki.embarcadero.com/RADStudio/Berlin/en/Master-Detail_Relationship_(FireDAC) The first one uses…
Marc Guillot
  • 6,090
  • 1
  • 15
  • 42
4
votes
1 answer

Table locks in SQLite accessed by fireDAC

I'm working on porting a set of paradox tables to SQLite. In order to do so, I created a test application that simulates (somewhat) the current usage scenario: multiple users accessing the same DB file and performing simultaneous read and…
Stephane
  • 3,173
  • 3
  • 29
  • 42
4
votes
1 answer

How to find DB Keys that uniquely identify records in a TFDQuery?

In a nutshell, how do I know which (primary & unique) keys uniquely identify a FireDAC query record ? I am using Delphi 10.1 & FireDAC & Firebird. I am using code generation to generate a file containing all the queries of my application. It is a…
Ludovic C
  • 2,855
  • 20
  • 40
1
2
3
…
53 54