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

Delphi XE7 embedded MySQL database

I used BDE before and deployed it with my apps and databases, and everything was very easy to setup. Now, I have Delphi XE7, FireDAC components and a MySQL database. Since I have WAMP, MySQL works for me and my database is located withing my local…
Savage
  • 11
  • 7
0
votes
1 answer

Can Delphi FireDAC work properly with SEE on android platform?

I'm a newbie for android development. I'm developing an mobile application run on Android devices with Delphi XE7. And now I'm searching the way to encrypt the sqlite database files accessed through FireDac on Android devices. I've found The SQLite…
Naoki
  • 53
  • 7
0
votes
0 answers

Firedac migration from BDE

My name is Stefano Fanti,I am a developer in Plexa.We are actually using your component ( FireDAC ) and I am contacting you in order to solve some problems we have not been able to fix ourself. In our company we decided to port a legacy 3-Tier…
Stefano Fanti
  • 1
  • 2
0
votes
1 answer

PlSql in Delphi with Firedac

I'm trying to run a plsql with firedac , but I'm not getting it. I've tried with FDScript1 and FDQuery1 . Is a parameter not found error . Does anyone know to run this plsql ? the error is FDQuery1: Parameter 'TALHAO_ID' not found. unit…
Rafael Maires Rangel
  • 91
  • 1
  • 10
0
votes
1 answer

FireDac MemTable Filtering Error on XE7

I am get an error that "Expression unexpectedly terminated" when i want to doing on the FireDac MemTable. I am use that codes with FMemtable1 Do begin Filtered :=False; Filter := 'Field1 like ' + ''''+'%'+Edit1.Text+'%'+''''; Filtered…
Hüseyin Okumuş
  • 21
  • 7
0
votes
0 answers

Max number of fields in FIREDAC select statement in runTime

I migrated my application from BDE to FIREDac. A routine that I use to update my database does not work: SELECT CODIGO , NOME , ENDERECO , ENDERECO1 , COMPLEMENTO , COMPLEMENTO1 , PONTOREFERENCIA , BAIRRO , CIDADE , UF , PAIS , CEP , CX_POSTAL…
Alisson Marcel
  • 1
  • 3
0
votes
0 answers

How do I call a MS SQL Server System Stored Procedure with Firedac?

I am converting my application from using raw ADO calls to using FireDac. Currently, I have the following line of code: TQueryRunner.ExecuteQueryNoMsg('exec(''sp_who @@spid'')', iRA,rs,conn,True); I need to be able to call that sp_id @@spid call in…
Nick Hodges
  • 16,902
  • 11
  • 68
  • 130
0
votes
1 answer

Sqlite auto timestamp - insert then display on DB aware grid

I have some experince with MySql, and am moving to Sqlite for the first time. The Sqlite documentation for data types, section 1.2 states that SQLite does not have a storage class set aside for storing dates and/or times. Instead, the built-in…
Mawg says reinstate Monica
  • 38,334
  • 103
  • 306
  • 551
0
votes
2 answers

delphi xe7 firedac locking on mssql server

I have got some strange problem withe FireDAC and locking on mssql-server and have no idea how this can happen. So I hope anybody has some experience and will help me :) We have got the following situation: In our application we have got a table…
Maggi_MT
  • 71
  • 6
0
votes
0 answers

TFDUpdateSQL not posting updates on Datasnap server

I am trying to setup a DataSnap server which provides data through an TFDQuery object. The query pulls data from multiple tables so I require a TFDUpdateSQL objects to post the data to the DB. I've managed to provide the data to the DataSnap…
D Clover
  • 45
  • 2
  • 8
0
votes
1 answer

Params.Size not correctly set

Situation is as follows: With upgrading from XE3 (anyDAC) to XE7 (Firedac), we suddenly are getting issues on updating a charachter field > 255 characters on Informix. We now get the error : '[FireDAC][Phys][ODBC]-345. Data too large for variable…
Copilot
  • 782
  • 6
  • 17
0
votes
1 answer

Firedac fetches oudated values within a few seconds after update

I'm currently maintaining a Client / Server (over TCP) system. The server can be accessed by multiple clients (few dozens at most) so i set up a connection pooling like FireDAC allow us to do. It works just fine in most cases. I'm still having one…
mathieu
  • 235
  • 2
  • 11
0
votes
2 answers

Getting an cursor as result when using begin and end block

I'm trying to use the results of multiple slq statements for one result(cursor) in the firedac query editor: Sql Command in editor DECLARE MyVar1 varchar2(100); MyVar2 varchar2(100); BEGIN SELECT USERINCDE INTO MyVar1 FROM P_USR WHERE…
P Horeweg
  • 3
  • 2
0
votes
1 answer

Copy and return FDDataSet from function in Delphi

I have function that should return FDDataset from FDQuery, but I can't copy dataset to Result, or to another FDDataset. This is my main Code: procedure TForm1.Button1Click(Sender: TObject); var: Fix: TFDDataSet; begin Fix.CreateDataSet; …
Gem
  • 516
  • 1
  • 8
  • 19
0
votes
0 answers

Delphi and mysql

I m trying to use mysql db from Delphi xe7, I' m using a simple app to get a DBgrid filled from a mySQL table. I have used one form and one datamodule. The form has a DBGrid and the Datamodule has the following : FireDAC Connection , Query ,…
koul
  • 431
  • 2
  • 10
  • 20
1 2 3
…
53 54