firedac Questions
7
Solved
I'm using Delphi XE5 on Windows 7 64bit and just trying FireDAC component.
I'm using one TFDConnection component to connect to local MySQL database (v5.6.15).
I already put the libmysql.dll (32bit...
3
I have a Firebird database with 3 million records. My FetchOptions are RowsetSize := 1000 with FetchAll disabled. I work on localhost.
I have no problem browsing page by page, but when I click on ...
Spurling asked 2/11, 2017 at 12:41
3
Solved
TFDConnection.Params.Server is not a valid published property in Delphi XE7. How can I set the server location programmatically? I have 2 MySQL servers (test and production) that are at different i...
3
Solved
What is the best way to connect to Google´s Firebase DBaaS from Embarcadero Delphi XE 10 ?
I am not sure how to do it from AnyDAC.
Or if exists a component out there (i coundnt find one on search)...
Ophthalmoscope asked 20/3, 2016 at 17:50
1
I was looking for a skip and take selection in the TFDQuery.
The properties I found are .FetchOptions.RecsSkip and .FetchOptions.RecsMax. I use Tokyo 10.2.3 and database Firebird 3
I make the quer...
Ong asked 19/4, 2018 at 12:35
2
Solved
After changing to FireDAC I have trouble getting this code to work on MSSQL/Oracle:
with DataFormsettings do
begin
Close;
if Params.Count=0 then FetchParams;
Params.ParamByName('TT_EMP_ID').Asi...
Elizbeth asked 6/12, 2017 at 11:17
0
Under FireDAC, I have a TFDConnection -> TFDQuery -> TDataSetProvider in a server app and a TClientDataSet in a client app. They are connected through the RemObjects Remoting SDK. (The TClien...
Argosy asked 8/12, 2017 at 15:47
1
Solved
I'm working on porting a set of paradox tables to SQLite. In order to do so, I created a test application that simulates (somewhat) the current usage scenario: multiple users accessing the same DB ...
Tachyphylaxis asked 1/11, 2017 at 12:30
1
Solved
I have a TFDConnection to a FireBird database for which I apply Data type mapping for backward compatibility with a previous data access technology (SQLDirect):
with FormatOptions.MapRules.Add do ...
Enlil asked 26/9, 2017 at 13:13
2
Solved
I open a TFDConnection for MS SQL Server with parameters:
DriverID=MSSQL
Password=test
User_Name=test
Server=VS2003-2008
Database=test
Single Connection=TRUE
Max Cursors=256
USE OLEDB=TRUE
I the...
Cubbyhole asked 26/9, 2017 at 14:9
3
I am trying to migrate my application from ADO to FireDAC. I am using Microsoft SQL Server. My database server was installed with collation SENSITIVE CASE and the database was created with collatio...
Pursuance asked 25/7, 2014 at 16:14
1
Solved
How we can get the count of affected by FDQuery.ExecSQL command of FireDAC after execution of INSERT, UPDATE or DELETE commands on table1 of SQLITE database?
FDQuery.SQL.Text:='UPDATE table1 SET c...
3
Solved
I am struggling using the in operator with FireDac.
I am using an oracle-database and cannot get a simple query working.
FDQuery1.SQL.Text := 'SELECT * FROM Customers WHERE Gender in (:Genders)';...
2
I am using Delphi XE8 with FireDAC to load a large SQLite database. To do so, I'm using the Array DML execution technique to efficiently insert a large number of records at once, like this:
FDQuer...
Tincture asked 20/7, 2015 at 17:19
0
I have migrated the database access components in our Delphi XE5 application from DBExpress to FireDAC.
So where I was using a TSQLConnection/TSQLDataSet, I am now using TFDConnection/TFDQuery.
...
Upgrade asked 17/4, 2015 at 14:32
1
Solved
I have grid control on form and when current record change i need to load RTF stored in DB. It works fine in general, but when i switch records i can see changes of mouse cursor to hourglass and ba...
2
I was using AsWideString to pass Unicode string to TADQuery parameter.
ADQuery.Params.ParamByName('MyFld').AsWideString
But when string becomes too long I got error:
[MyFld]. Max len = [8002], ...
1
© 2022 - 2024 — McMap. All rights reserved.