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
3 answers

Change a FireDAC query SQL string from DataSnap client

I have set up a client connecting to a DataSnap Server in Delphi XE7. I need to send a SQL string created on the client to the server to be executed against a Firebird DB. I am using FireDAC, but I get similar results if I use DB Express. I…
Nick Alexander
  • 1
  • 1
0
votes
1 answer

Loading a blob field into a ListBox

I had a question answered earlier in the week and I need to take things a stage further I am using XE7 and i have a problem loading a blob field (Image.jpg) from a table into a ListBox or even into a variable which I can later enter to the Listbox.…
Cazhou
  • 11
  • 1
  • 5
0
votes
1 answer

Enabling SQLite Foreign Keys without command

Is there a way to enable the SQLite Foreign Keys with the TFDQuery component and without using a sql command? I build a SQLite DB with foreign keys and it works, also without enabling that option. However, I might better use it. LuMa
LuMa
  • 1,673
  • 3
  • 19
  • 41
0
votes
1 answer

How can I migrate from C++ XE3 to XE7 with FireDAC?

I have an app writen in C++ Bulder XE3 and now i want to upgrate to XE7. But I use FireDAC for connection with PostgreSQL and in XE3 the connection is called ADConnection and query ADQuery and in XE7 FDConnection and FDQuery. I what to find an easy…
Anca Birsan
  • 1
0
votes
1 answer

Setting Up TSQLConnection to connect an Oracle Database in XE6

I am creating a mobile app in RAD Studio XE 6 to handle a remote Oracle Database that is stored in a server. I am completely new in RAD Studio and newer in Oracle Databases. I have read a lot everywhere about how to set up a TSQLConnection using a…
Ricardo Rodriguez
  • 106
  • 9
0
votes
1 answer

Delphi XE6 FireDac Master Detail error

I have two tables in a master Detail relationship. Using TFDTables. I display the detail table in a TDBGrid When I call up the master table I can successfully create one detail record. When I try to add a second the problem starts. The system does…
farley
  • 149
  • 2
  • 16
0
votes
0 answers

Opening and closing database connections in multiuser environment

This is a multiuser application (multithreaded) where various departments will access their own database.The database is SQLite and I am using FireDac.For each department I have assigned a separate ADConnection so I dont get any unexpected…
user3777264
  • 72
  • 1
  • 9
0
votes
1 answer

Migrate From DevArt UniDac To FireDac

I've been using UniDac for 2 years now and it was the best solution for me, but because it doesn't support Asynch query's i have to move on to FireDac is there any quick migration wizard or something that i can use because i have around 200+…
AirWolf
  • 597
  • 7
  • 27
0
votes
1 answer

Master/Detail DataSnap via FireDac and MySql ¿Why data written into a detail record in one client is not seen from a second client?

I have a DataSnap Server with two TFDQuery's via TFDConnectionto a MySQL database. This querys are in a master/detail relationship via a TDataSource (neested datasets). This data is exported via one TDataSetProvider. In the client side, I have a…
rlascarez
  • 21
  • 5
0
votes
1 answer

Data validation in Delphi using TField.CustomConstraint

I'm using Delphi 6XE, with MySQL as database server. I have table's fields as shown below I'm using FireDAC. I'm trying to implement data validation using TField.CustomConstraint, so I use the Field Editor to generate TField descendant objects as…
Artisan
  • 4,042
  • 13
  • 37
  • 61
0
votes
3 answers

Using GetLastAutoGenValue

I am using fireDAC TFDQuery to insert values in informix database, using below code snippet: with QHeaderQuery do begin if not (Prepared) then begin {DatabaseName := Sessions.CurrentSession.Databases[0].DatabaseName; SessionName :=…
user3406438
  • 63
  • 7
0
votes
1 answer

Is Platform Assistant Server necessary to run fireDAC application to connect to Informix?

I am trying to connect my Delphi application to Informix database using fireDAC. I all the parameters supplied in connection editor. But I have to run PA Server to make it work. So is it necessary to run the PA Server to connect to Informix db.
user3406438
  • 63
  • 7
0
votes
0 answers

Firedac / Anydac query issue when using updatesql components

The following question is related to firedac using adquery, updatesql with access database: First the scenario: In one of scenario my updatesql gives an error i-e data in the table was not updated, however my dataset after showing error moves to…
Khawar
  • 33
  • 1
  • 6
0
votes
1 answer

Oracle + FireDac return empty strings

All my oracle varchar2 data returns empty(EmptyStr) using an firedac connection + firedacQuery. I tryed an ADO connection on same database and all strings appear normally. Can anyone explain? Im using delphi XE5 + oracle 11g, database charset is…
Luciano
  • 21
  • 4
0
votes
0 answers

Unable top execute delphi fireDAC Application on remote PC

I have created an application in Delphi XE5 using Informix as DB and fireDAC as data access method. Now I want to install this application on some other remote PC. What are per-requisites for that. I mean what remote PC should have before I start…
user3253155
  • 1
  • 1
1 2 3
…
53 54