Connecting a VCL Application to SQL Server Using FireDAC in RAD Studio
Learn how to link a VCL form to SQL Server with FireDAC, run a parameterized query, and show results in a grid while handling errors and cleaning up resources.
Loading…
ReadMeFeed / Community knowledge
#firedac
Real questions. Useful conversations. Find the people who know your stack.
Optimizing Large Dataset Retrieval with FireDAC TFDQuery Pagination
Learn how to use FireDAC's TFDQuery FetchOptions to implement on-demand pagination, reducing memory overhead and preventing application crashes when handling large datasets in RAD Studio.
radstudioFireDAC and EMS credential expiration and least-privilege boundary
Integration boundary A Delphi application is planned to use FireDAC for least-privilege database access and RAD Server/EMS for token-based API access. The design goal is consistent credential use and handling of expired credentials across the two component boundaries. FireDAC supports least-privilege access via connection parameters and delegates authenticat
delphiFireDAC schema changes: wrap DDL in one transaction or go forward-only with compensating scripts?
I'm designing a schema migration strategy for a RAD Studio (Delphi) application that uses FireDAC against more than one target DBMS. The goal is a rollback-safe upgrade path when a schema change fails partway through. Two documented approaches seem viable. First, wrap the DDL in an explicit transaction using TFDConnection.StartTransaction / Commit / Rollback
FireDAC and DBMS Interoperability: Server-Side Pagination Consistency
Pagination via FetchOptions In Delphi 10.4 and later, TFDQuery provides FetchOptions.RecordCount and FetchOptions.RecordsSkip to implement server-side bounding. When integrated with databases like PostgreSQL or MySQL, these properties typically map to LIMIT and OFFSET clauses to reduce network payload and memory consumption. DBMS Compatibility Constraints A
TFDMemTable CachedUpdates and Remote Data Synchronization
The TFDMemTable component in Delphi is often used to decouple the UI from the database by mirroring remote data in memory. When the CachedUpdates property is enabled, changes are queued locally to minimize server round-trips. A challenge arises when the underlying database is modified by external processes while the TFDMemTable holds pending local updates. B