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

Cannot compile SQLite application in XE3

When trying to use an SQLite connection in a Win32 project on XE3 using version 8.0.5.3365 of FireDAC I'm getting the following error: [dcc32 Fatal Error] uADPhysSQLiteCli.pas(992): F2051 Unit uADStanCipher was compiled with a different version…
Copilot
  • 782
  • 6
  • 17
0
votes
1 answer

Unknown driver Informix

I am using fireDAC to communicate with my informix driver from delphi application. After setting the connection parameters using dbExpress gateways : My connection parameters…
user3253155
  • 1
  • 1
0
votes
0 answers

What is Vcl.Bind.DBEngExt

What is Vcl.Bind.DBEngExt and why is it being added to the uses statement in my Data Module in a Fire Monkey application? As far as I can tell I don't have any VCL components in that unit, nor anyplace in the application. As a result whenever I…
gwardell
  • 90
  • 2
  • 11
0
votes
2 answers

Android delphi application Segmentation fault (11) exception when calling Firedac

I have problem with Delphi XE5 Firedac application. I use ZTE Blade 3 phone to run application. I used deployment manager to add database file to assets\internal directory. But when I call FDQuery1.FieldByName('Nimi').AsString it raises exception…
user3146414
  • 89
  • 2
  • 6
0
votes
1 answer

FireDAC how connect to Firebird

We want to migrate BDE Database to FireBird embedded in DELPHI XE3. After installing FireDAC I couldn't establish connection to Firebird from FireDAC.In DriverID combobox list of FireDAC connection Editor there is no FireBird driver. According to…
Avrob
  • 533
  • 2
  • 10
  • 20
0
votes
0 answers

FireDac installation in XE4 fails

I have installed Delphi XE 4 Enterprice Update1 on my computer. I tried to install Fire DAC 8.0.5.3365, but during installation got many errors like: Source\uADStanCipher.pas(181) Error: E2010 Incompatible types: 'Byte' and…
vico
  • 17,051
  • 45
  • 159
  • 315
0
votes
3 answers

Direct connect to FirebirdSQL with FireDAC on Android?

I need a direct connect to FirebirdSQL 2.x database (no DataSnap ). Is it possible, and how ?
Yordan Yanakiev
  • 2,546
  • 3
  • 39
  • 88
0
votes
1 answer

AnyDac - How to disconnect from in-memory sqlite db?

I'm using in-memory SQLite databases with AnyDac on Delphi XE2. I noticed that my queries return results even when I forget to connect the database first after restarting the program, which is probably caused by the autoconnect capability of AnyDac.…
Jasper
  • 62
  • 3
0
votes
1 answer

FireDAC SQLite backup saves no data

When executing the following code, the database file only has table names. No field names or actual data seems to be getting copied over. procedure TdbModule.BackupDB(); begin ADConnection1.Connected := True; ADSQLiteBackup1.DatabaseObj :=…
Dan
  • 303
  • 1
  • 13
-1
votes
1 answer

Delphi FireDAC TFDQuery SQL Server DataTime filter problem

For the life of me, it seems I can't filter my TFDQuery using a DateTime field/format. I have this query that needs to "import" filters from a component (cxGrid), among them are: "Date = " (DateTimeField); "Value = " (FloatField); "Supplier = "…
SpecialDuck
  • 21
  • 3
-1
votes
1 answer

the database column is not found even though it exists (firedac)

There is this listbox which gets populated with the name of the columns of a database in Delphi (Radstudio, Firedac). Depending on the listboxitem selected by the user, the data of the relevant column should then be loaded into another listbox. To…
hsh_Ar
  • 93
  • 7
-1
votes
1 answer

FireDAC: possibility to make query faster - Delphi

I use bind variables in Delphi and on the other side there is Oracle database with Database link (@dblink). When I build a SELECT statement without bind variables, it has no problem with performance. Only if I query SELECT statement with bind…
Niko
  • 69
  • 7
-1
votes
1 answer

How to Select some fields have same prefix Names

Using Firedac, is there a way to select a set of columns that have name beginning with same prefix? Suppose we have columns Fields : PREFIX_col1, PREFIX_col2, ... Is it possible to do a request like : SELECT 'PREFIX_*' FROM mytable; i have this…
Roberto
  • 105
  • 7
-1
votes
1 answer

Delphi IBX to Firedac Migration For Firebird

I migrated an IBX application which have 500+ forms to Firedac. I mapped the datatypes with Delphi Help. Here is my data mapping: with ADB.FormatOptions do begin OwnMapRules := True; DefaultParamDataType := ftVariant; …
ErkanK
  • 95
  • 7
-1
votes
1 answer

Set database value to NULL

I have an SQLite double field that is used to display a date. There is no default value for the field. I need the field value to be NULL when there is no date entered because when the field is displayed as a date, it shows '12/30/1899'. For some…
Earl
  • 9
  • 6
1 2 3
…
53 54