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

Delphi - Connect to Teradata DB (on virtual machine) with FireDAC

Cut to the chase: Windows 10 x64 host machine runs VMWare Player 12 which runs 'TDE 16.00.04 SLES 11' linux OS downloaded from teradata website. The virtual machine is pre-installed with teradata DB and it works fine, I can connect to it with…
Laszlo Szilvasi
  • 41
  • 1
4
votes
1 answer

How to properly access a VARCHAR(MAX) parameter value of a FireDAC dataset when getting "data too large for variable" error?

Our application updates and accesses data using SQL Server 2014. I have a table of which the last column ('Contents') is created as VARCHAR(MAX). We are using Delphi XE8, and are using a FireDAC TFDQuery component to update this column.…
Alex
  • 543
  • 1
  • 9
  • 21
4
votes
2 answers

Delphi unit automatically gets added to uses in Seattle

In my Firemonkey multi device project the IDE keeps adding the unit "FireDAC.VCLUI.Wait" to my uses in a data module of my project. This unit keeps me from building the project, because it can't resolve the name in Android or iOS. The strange thing…
Remi
  • 1,289
  • 1
  • 18
  • 52
4
votes
0 answers

SQLite Exception when trying to open a connection with multiple processes

My scenario is simple, I have one process generating some data and putting it into the database (currently 5 seconds after the last one is finished) and then there are any number of processes opening a connection to read a single record to use…
Clayton Johnson
  • 279
  • 4
  • 16
4
votes
1 answer

How to apply a cached update FDQuery using Delphi FireDAC with an UNIQUE constraint on the database

I have a problem to resolve cache updates when delta includes fields that have UNIQUE constraint on the database. I have a database with the following DDL schema (SQLite in memory can be used to reproduce): create table FOO ( ID integer primary…
Guinther Pauli
  • 71
  • 1
  • 5
4
votes
0 answers

Mocking the FireDAC

I just entered the Delphi's Unit Testing area - never have done it in Delphi. The things went fine until I came to database connection and queries. I am using TFDConnection and TFDQuery in data access classes. I found an article stating that for…
Paul
  • 25,812
  • 38
  • 124
  • 247
4
votes
1 answer

Big Array DML (FireDAC) work failded with PostgreSQL

I need to insert a big batch rows to my PostgreSQL(v9.5) table. Here is the table: create table TaskLog( id serial, taskid integer, x double precision, y double precision, loc character varying(50), speed smallint, gpstime timestamp…
Leo
  • 1,947
  • 2
  • 20
  • 37
4
votes
1 answer

Release memory for array DML operations

I am using array DML operations to speed insert of large number of records into SQL database. The principle is described here. Sample code how this functionality is used: TFDQuery *FDQuery1; ... FDQuery1->SQL->Text = "insert into MyTab values (:p1,…
truthseeker
  • 1,220
  • 4
  • 25
  • 58
4
votes
1 answer

FireDac freezes GUI

I am working with FireDac under Delphi 10.1 Berlin. For displaying data to the user i use data aware controls like TDBEdit. I use TFDQuery and TDataSource to link them with the controls. This works but long sql queries that take some time to…
Tommy
  • 596
  • 6
  • 30
4
votes
3 answers

How can I create a new SQLite file and table at runtime using FieldDefs?

I'm using Delphi Seattle to create a brand new table in a brand new SQLite file and using only FieldDefs and non-visual code. I can create a table using the ExecSQL ('CREATE TABLE....' ) syntax but not as shown below (I get 'No such table 'MyTable'…
Brian Frost
  • 13,334
  • 11
  • 80
  • 154
4
votes
1 answer

Delphi FireDAC TFDQuery event 'AfterOpen' never executes

I'm trying to execute an sql query asynchronously. I've checked the example code from http://docwiki.embarcadero.com/RADStudio/XE5/en/Asynchronous_Execution_(FireDAC) and also the example project from directory ..Samples\Object…
Viktor Anastasov
  • 1,093
  • 3
  • 17
  • 33
4
votes
0 answers

Custom Delphi action class

I wrote some basic TAction classes (like TDataSetAdd or TDataSetReOpen) and it works like a charm. Now I tried to write an action to handle commit of a transaction but for some reason it behaves somewhat unexpectedly. "HandlesTarget" function never…
kidbabic
  • 109
  • 2
  • 11
4
votes
3 answers

Descending sort in TFDTable results in duplicate rows

When using TFDTable in LDW mode, descending sort of fields results in duplicate rows. For example: TFDTable.TableName is set to a VIEW name (not a tablename) TFDTable.UpdateOptions.KeyFields is set to the primary key in the VIEW base…
cytrinox
  • 1,846
  • 5
  • 25
  • 46
4
votes
1 answer

FDQuery (SQL) results to array of records in Delphi

Is there a way to copy FDQuery results to array of records directly? So this is declared types: type TPerson = record id: integer; name: string; surname: string; end; type TPersonList = array of TPerson; and I have SQLite DB with…
Gem
  • 516
  • 1
  • 8
  • 19
4
votes
1 answer

Connecting to an remote Oracle XE11 database using FireDac and OSX Mavericks

I made a small application that should connect to an remote Oracle database running inside a virutal machine (W8.1). On a sucessfull connection a showmessage should popup. I folled those steps to ensure my application is able to connect: installing…
ChrisB
  • 2,497
  • 2
  • 24
  • 43
1 2
3
…
53 54