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

FireDAC TFDScript error trying to drop a non-existent table

I have a nasty error when executing a Firedac TFDScript error trying to drop a non-existent table: Delphi Berlin 10.1 Upd 2 Database Firebird 2.5 It give an error when calling FDScript.ExecuteAll (it passes the FDScript.ValidateAll without any…
Fabio Vitale
  • 2,257
  • 5
  • 28
  • 38
3
votes
6 answers

Delphi Delete all records from FDTable

Iam trying to delete all records in my FDTable component using , mytable.Delete; but no record is getting deleted. can any one suggest me a way to delete all records in a FdTable. EDIT i modified it in this way, for i := mytable.RecordCount - 1…
userhi
  • 553
  • 1
  • 7
  • 27
3
votes
1 answer

Cannot connect to mySql from a lan network computer

I have a MySql Server 5.7 running as service on one computer of a LAN. My application is installed and running fine on the same computer. I have 'Shared with everyone' set for the directory where my application is located. In the same directory I…
R.Drolet
  • 39
  • 3
3
votes
1 answer

Getting error using a parameter with anydac (now firedac) script for firebird

I'm unable to get the following script to execute without error.. It's running in delphi against a firebird database. var vScript: TADScript; begin vScript := TADScript.Create(nil); vScript.Connection := xConnection; vScript.Transaction :=…
cjmarques
  • 632
  • 1
  • 7
  • 17
3
votes
1 answer

NVarchar(max) to XML parse error

Have the following configuration: Delphi XE7 MS SQL Server 2008 Connection to the SQL server with FireDAC I'm using stored procedures to retrieve tables with all the detail records from SQL server in XML format converted to nvarchar(max). Here is an…
BenjiK
  • 45
  • 4
3
votes
1 answer

Delphi FireDAC hanging on ISAPI module (bpl) finalization with pooled connections

I've written an ISAPI module in Delphi XE10 using pooled FireDAC connections. In the unit's finalization section, I have the code: Finalization FDManager.Close; The application freezes on the FDManger.Close line. I have the Professional Delphi…
Steve Kramer
  • 107
  • 6
3
votes
1 answer

How to get FireDAC record count when SetRange active

I'm slowly moving from ClientDataSet to FireDAC FDQuery components in my projects (Delphi 10 Seattle). One trick I often use with CDS is to check record count on a range. That is: CDS.SetRange([Value1][Value2]); k := CDS.RecordCount; case k of…
edbored
  • 274
  • 4
  • 11
3
votes
1 answer

Fill FDQuery/Dataset with stored DB infos from XML file

I have an XML file where I store database infos (TableName, Records etc) Are there any way to load Records to a Query or Dataset from the file? I want to change TablaName parameters and after I want to fill the database with Table Records. Thanks…
Steve88
  • 2,366
  • 3
  • 24
  • 43
3
votes
1 answer

How to use Delphi design-time FireDac TFDQuery when using multiple threads?

I want to design my TFDQuery using the component editor, i.e. set the SQL string, options etc. during design-time and then use the query in a thread. My problem is that each running instance of the thread needs its own instance of the query -…
Floris
  • 1,082
  • 10
  • 26
3
votes
1 answer

Insert to Oracle Blob Field by FireDac

I am using FireDac to connect to my oracle database. To insert blob fields I use this code: procedure TForm1.btn1Click(Sender: TObject); begin try fdqry1.Open('select * from Tbl_Image where length(fld_content) > 0'); try while not…
Asghar Nemati
  • 71
  • 9
3
votes
0 answers

How to remove static linking from Firedac SQLITE

I'm currently using Delphi XE7 Update 1 with FIREDAC actually it seems that FireDac links statically the sqlite3.dll but it uses an old version , what i want to do dynamcally link the newest library to my application , I have followed that link…
deadc0der7
  • 301
  • 5
  • 17
3
votes
3 answers

How to receive MySQL database notifications in Delphi?

I am developing a Delphi XE7 application with data stored in an online Mysql database. For the database access I use FireDAC. Because the application can be used on more than one computer simultaneously I need to be notified when a table is changed,…
Mark Broek
  • 31
  • 1
  • 4
3
votes
1 answer

Firedac ODBC and Ingres database - "API function cannot be called in the current state"

i have problem with reading data from Ingres database by Delphi Firedac(ODBC). I can connect to Ingres database (no exception throw) but when i try to read data by FDQuery i got: "API function cannot be called in the current state" With the same…
Livius
  • 958
  • 1
  • 6
  • 19
3
votes
1 answer

FireDAC TFDConnection.GetTableNames doesn't work on Firebird with trusted authentication

I'm connecting my Firebird database with FireDAC (migrating from FIBPlus and using XE8 update 1). I'm using trusted authentication (OSAutenth=True). I need to read the list of tables within the database. I'm using the TFDConnection.GetTableNames and…
user2306408
3
votes
1 answer

Check if database has support for transactions using FireDac

How can I check if the DBMS has support for Transactions, using FireDac components? Usually, I use something like the follow code, to perform a transaction in my DAO class, using dbExpress. ... connection: TSQLConnection; dbxTransaction:…
rodrigopandini
  • 945
  • 1
  • 7
  • 18
1 2 3
…
53 54