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

libpq.dylib x86 client library

I have a FMX application that should run in Windows and MAC. The application uses FireDac and needs to connect with Postgresql and Firebird. The windows side works perfectly. On the MAC side I was able to find the x86 dylib files and make it work,…
Sam
  • 2,473
  • 3
  • 18
  • 29
-1
votes
1 answer

Delphi - multiple users (sessions) after login (FireDAC)

I am working on Windows desktop application in Delphi using FireDAC driver and MSSQL database system. Currently, I am having a problem in understanding how multiple sessions (users) should work. Right now, I have three test users, and when I log in…
user9818764
  • 1
-1
votes
1 answer

Delphi - FireDAC events

I have the following form in Delphi: Note: I am using FireDAC database driver, and TDBGrid component. Note: I am using test column names and data for this question. If you want, I can send you complete database tables, but they are in Serbian. Here…
user9784250
  • 5
  • 2
-1
votes
1 answer

Using FDQuery.RecordCount to tell if the query is empty or not may return negative value in Delphi

I have an FDQuery on a form, and an action that enable and disable components according to its recordCount ( enabled when >0). Most of times recordCount property return the actual count of records in the query. Sometimes, recordcount return…
Federico Pessina
  • 199
  • 1
  • 4
  • 15
-1
votes
1 answer

Firedac multiparametric query with macro

I created the main query that returns values for a whole, with 2 secondary conditions to restrict choice to be taken in the side combo box. Everything works with the set parameters. I wish I could turn off or turn on these conditions with side…
Nu Carvignulu
  • 61
  • 1
  • 1
  • 15
-1
votes
1 answer

Connecting to SQLServer with Firedac in Delphi 10 Seattle

I am using a grid to enter data and find that my fields that are marked as NOT NULL but have a DEFAULT CONSTRAINT eg. int = 0 are not being automatically updated with the default value.
GlynB
  • 1
-1
votes
1 answer

If statement test on FDQuery,FieldListDef doesnt work

if (FDQuery.FieldDefList.FieldDefs[i].Name <> 'TKey') and (FDQuery.FieldByName(FDQuery.FieldDefList.FieldDefs[i].Name).AsString <> '') then begin ....... end I are migrating code from NexusDB to using MySql. The table in question has data…
Daniel Rogers
  • 39
  • 8
-1
votes
1 answer

Delphi Combo Edit from CSV File

I have an application that will load a CSV file containing two columns. At program load I need to have the first column as items in a combo edit control. Once the user selects (or enters a value) I need to populate a label with the value from the…
Larry
  • 1
-1
votes
3 answers

Filter database table/query whilst typing in TEdit box

I have a form which has a cxGrid on it and connects to a database table via TADQuery (FireDAC). I've also added a TEdit box to the same form. When a user starts typing into the TEdit box, can I make the grid start to filter the results based on what…
Sharpie
  • 373
  • 2
  • 15
  • 34
-1
votes
1 answer

FireDac connection string to FireBird 2.5 embedded

I tried this but it seems it does not work: procedure TDataModule3.DataModuleCreate(Sender: TObject); begin FDConnection1.Params.Values['Database'] := ExtractFilePath(ParamStr(0)) + 'MYDB.fdb'…
user3927897
  • 611
  • 3
  • 10
  • 20
-1
votes
3 answers

Show sqlite query results in a TEdit - Firemonkey Mobile application?

I have an sqlite database and i want to execute a select query and show the result in the TEdit. How can i do it? query := 'SELECT username FROM users'; //The query returns only one row FDQuery1.ExecSQL; FDQuery1.Open(); Edit1.Text := ??
Christos K.
  • 99
  • 3
  • 14
-2
votes
1 answer

Delphi FireDac network encryption with Oracle

I'm looking for a possibility to encrypt the connection to our Oracle database. I did find this post below: How to encrypt FireDAC connection to use TLS/SSL in Delphi? The only answer I see there is that we have to buy ($3000/developer, wow) and use…
Paul Sinnema
  • 2,534
  • 2
  • 20
  • 33
-2
votes
1 answer

Delphi SqLite, firedac, Stuck at black loading screen with fire icon

I am working on a simple android app that uses sqlite. I have a simple multi device app. There is a list view connected to the fdquery1, and fdconnection1. When i compile to my android phone i get the black screen with fire icon. If i turn of the…
grant1842
  • 357
  • 1
  • 7
  • 23
-2
votes
1 answer

How to return data from the database with Delphi function?

My Delphi application is connected to postgres database using firedac.I want to write a delphi function which can return result of select query.What should be the code and return type of the function?
Arati Padgaonkar
  • 19
  • 2
  • 8
-2
votes
1 answer

Install FireDAC in Borland Delphi 6

I searched on Google and know that: FireDAC component is not available on Borland Delphi 6 (but available on RAD Studio). I try to install FireDAC through Component, but I did not find unit/package of FireDac. Is there any other way, or that is…
Richard Anderson
  • 13
  • 3
1 2 3
…
53
54