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

FireDAC FDBatchMoveTextReader change filed data type at runtime

I am trying to parse different text files using FDBatchMoveTextReader. I use GuessFormat procedure solely to determine field count. Therefore, I set AnalyzeSample to 10 lines. I am trying to manually set each field's data type to string after…
Ertan Küçükoglu
  • 31
  • 11
0
votes
1 answer

How to insert several lines batch SQL? { UNIDAC/FIREBIRD]

how insert multiple lines SQL/batch in UNIDAC equal to FIREDAC? Firedac example: FDQuery.ParamByName ('NAME') AsStrings [0] = 'MARIA'; FDQuery.ParamByName ('NAME') AsStrings [1]: = 'JOHN'; FDQuery.ParamByName ('NAME') AsStrings [2]: =…
Warquia
  • 19
  • 5
0
votes
0 answers

How to encrypt a firedac TFDmemTable backup file?

TFDmemTable has a SaveToFile option including Binary format but if you open the binary file with notepad, you can see all the text. Is their a way to encrypt this file?
user3516612
  • 21
  • 1
  • 4
0
votes
1 answer

"type mismatch expecting AutoInc actual LongWord" on FDQuery (Delphi XE6)

We use Delphi XE6 the component with error is a TFDQuery in MySQL 4.1. When I try to open the Query using a group the FDQuery show: type mismatch expecting AutoInc actual LongWord In the Field Editor the field is correct,it shows AutoInc but the…
SisMaster
  • 67
  • 7
0
votes
1 answer

How to have blank/null for AutoInc field in FireDAC for new record instead of negative number?

By default, FireDAC uses negative numbers for AutoInc field for new records not yet posted to the database. How do you get the AutoInc field to be null and therefore show blank on a dbgrid? Thanks.
coderboy
  • 148
  • 6
0
votes
1 answer

Using FireDAC MS Access services (Delphi XE6)

I am using the TFDMSAccessService component to create a MS Access database. This works in the 32 bit compiler and obviously uses the 32 bit ODBC components to create the database. However, for a 64 bit version there are no ODBC drivers if you have…
Tom Dalton
  • 21
  • 4
0
votes
1 answer

how to update another table before relevant data for update gets deleted from current table

I am deleting records from the table 'posoja' with this : procedure TForm2.cxButton3Click(Sender:…
user763539
  • 3,509
  • 6
  • 44
  • 103
0
votes
0 answers

FireDac: Incorrect syntax near the keyword 'declare'

I want to run the following query: Qry.SQL.Text := 'declare @test bit; set @test = 1; select @test;'; Qry.Open; This causes the error "Incorrect syntax near the keyword 'declare'", but the Query shows the expected "1". If I run that sql in the…
Maggi_MT
  • 71
  • 6
0
votes
2 answers

Delphi XE6 FireDAC - Export TFDQuery recordset to JSON

I'm using FireDAC in Delphi XE6 to query a database (Pervasive) through ODBC. I have a TFDQuery component which runs my SELECT query and returns the records. Once the query is complete I want to export the data in the recordset as JSON. I've…
Jonathan Wareham
  • 3,357
  • 7
  • 46
  • 82
0
votes
0 answers

Password change by TFDGUIxLoginDialog

I am trying to implement changing of password in MySQL DataBase using FireDAC. Unfortunately, RAD XE5 Help system lacks information on TFDGUIxLoginAction (parameter of this type is used in Execute method of TFDGUIxLoginDialog). Google gives 5 links,…
asd-tm
  • 3,381
  • 2
  • 24
  • 41
0
votes
0 answers

Application closing when Activating the Connection on FireDAC

I developed an application that uses FireDAC to connect to a MySQL Database. But when I try to open it on a workstation, at the moment that I set the Connected := True; on the TFDConnection, the application closes itself without showing an…
Francisco Godienski Hansen
  • 319
  • 6
  • 17
0
votes
2 answers

Delphi XE7 TFDTable View RowID error

I'm converting a Delphi 5 / BDE application to Delphi XE7 / FireDAC. One of my forms has a TFDTable component that points to an Oracle view containing a group by clause in its create statement. This used to work fine in the BDE application, but with…
oxydog
  • 1
  • 2
0
votes
2 answers

Datasnap\FireDAC: Query executed twice

I have the following problem: 1) I use Delphi XE7 to develop a 3-layer system. 2) The server layer, created with datasnap using REST. 3) I use Firebird as database and the access is performed with FireDAC. 4) I have a sequence with value 01. 5) I…
Luiz
  • 113
  • 7
0
votes
1 answer

[FireDAC][Phys][FB] file is not a valid database

I have a problem when accessing a GDB-DataBase via the FireDAC.FB-Driver. The strange thing here is, that if I set up the connection at designtime, everything works fine with DriverID = FB Server = 127.0.0.1 Protocol = TCPIP If I try the same…
Art1st
  • 123
  • 2
  • 11
0
votes
1 answer

Registering a Firebird Blob Filter using FireDac (Delphi)

Having used Firebird SQL and Delphi for years I have always registered my own Blob Filters using FBPlus from Devrace. As Delphi now ships with FireDac I am hoping to shift over to this technology, removing the requirement of third party data access…
Reallyethical
  • 1,825
  • 2
  • 16
  • 26
1 2 3
…
53 54