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

680 questions
12
votes
3 answers

Delphi Firedac - Case Sensitive issue

I am trying to migrate my application from ADO to FireDAC. I am using Microsoft SQL Server. My database server was installed with collation SENSITIVE CASE and the database was created with collation INSENSITIVE CASE. I did this configuration because…
MarceloSouza
  • 395
  • 3
  • 8
9
votes
3 answers

SQL Prepared Parameter FireDac using "in"-clause

I am struggling using the in operator with FireDac. I am using an oracle-database and cannot get a simple query working. FDQuery1.SQL.Text := 'SELECT * FROM Customers WHERE Gender in (:Genders)'; FDQuery1.ParamByName('Genders').AsString:= 'M'; It…
Tommy
  • 566
  • 4
  • 29
9
votes
1 answer

How to avoid of hourglass mouse cursor when executing SQL query with TFDQuery in Delphi XE5

I have grid control on form and when current record change i need to load RTF stored in DB. It works fine in general, but when i switch records i can see changes of mouse cursor to hourglass and back to regular: function TComments.GetDocument(AID:…
Andrei Galatyn
  • 3,193
  • 2
  • 18
  • 36
8
votes
2 answers

Parameter.AsString failing under Oracle/MSSQL - Parameter.Value 2-byte chars under Oracle

After changing to FireDAC I have trouble getting this code to work on MSSQL/Oracle: with DataFormsettings do begin Close; if Params.Count=0 then FetchParams; Params.ParamByName('TT_EMP_ID').Asinteger := AEmpID; …
Jan Doggen
  • 8,154
  • 13
  • 56
  • 117
8
votes
2 answers

The Fastest Way to Load an Array DML in Delphi FireDAC

I am using Delphi XE8 with FireDAC to load a large SQLite database. To do so, I'm using the Array DML execution technique to efficiently insert a large number of records at once, like this: FDQueryAddINDI.SQL.Text := 'insert into indi values (' +…
lkessler
  • 19,414
  • 31
  • 125
  • 196
7
votes
3 answers

how to store data on Firebase - Delphi XE 10

What is the best way to connect to Google´s Firebase DBaaS from Embarcadero Delphi XE 10 ? I am not sure how to do it from AnyDAC. Or if exists a component out there (i coundnt find one on search) Any help? thank you
diego
  • 145
  • 2
  • 8
6
votes
3 answers

FDQuery causing Out of memory exception

I have a Firebird database with 3 million records. My FetchOptions are RowsetSize := 1000 with FetchAll disabled. I work on localhost. I have no problem browsing page by page, but when I click on "goto last record" button in the DBNavigator, it…
Niyazi Korkmaz
  • 61
  • 1
  • 4
6
votes
3 answers

Setting "Server" programmatically with a TFDConnection

TFDConnection.Params.Server is not a valid published property in Delphi XE7. How can I set the server location programmatically? I have 2 MySQL servers (test and production) that are at different ip's and based on what I am doing in the application,…
user2021539
  • 879
  • 3
  • 14
  • 25
5
votes
2 answers

How do I setup an ODBC connection to Oracle using FireDAC?

I can succesfully connect to Oracle through the native drivers, but cannot get an ODBC connection to work. The Oracle 11g client software is installed on my Windows 7 64 bit machine, as well as the 32-bit ODBC drivers downloaded from Instant Client…
Jan Doggen
  • 8,154
  • 13
  • 56
  • 117
5
votes
1 answer

Get text[] value from sql table with FireDAC on Delphi

On pgAdmin with a simple query 'select * from data' I got only one record containing a field type text[] with value '{"1","2","3"}'. The following simplified code gives back only the "1" part of the value: function GetData: string; var q:…
FGabor
  • 53
  • 3
5
votes
1 answer

AV when releasing a Form after compressing and sending a TFDDataset's Data

I have an AV when releasing a Form, it appears when I compress and send a FireDAC Dataset's data to a remote server. This is the code I use to compress the TFDDataset's Data: function CompressDataset(Dataset: TFDDataset): TMemoryStream; var Data:…
Marc Guillot
  • 5,367
  • 11
  • 30
5
votes
6 answers

Can't retrieve TStreams bigger than around 260.000 bytes from a Datasnap Server

I have a Delphi 10.1 Berlin Datasnap Server, that can't return Data packets (through a TStream) bigger than around 260.000 bytes. I have programmed it following the \Object Pascal\DataSnap\FireDAC sample from Delphi, which also shows this…
Marc Guillot
  • 5,367
  • 11
  • 30
5
votes
1 answer

FireDac get the count of rows affected by FDQuery.execsql command

How we can get the count of affected by FDQuery.ExecSQL command of FireDAC after execution of INSERT, UPDATE or DELETE commands on table1 of SQLITE database? FDQuery.SQL.Text:='UPDATE table1 SET col1='abc' WHERE id<100'; FDQuery.ExecSQL; How we can…
Avrob
  • 363
  • 1
  • 8
  • 18
5
votes
1 answer

How to enable WireCompression on Firebird 3.0 using FireDAC

I am looking to connect to Firebird Server 3.0 using WireCompression. This being new feature since version 3.0 I'm having a hard time to get it to do so and the only documented instructions I can find is setting WireCompression to TRUE in…
Christiaan ten Klooster
  • 141
  • 8
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
  • 5,367
  • 11
  • 30
1
2 3
…
45 46