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.
ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
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.
Goal: ensure safe recovery from a failed Knex migrate:latest on MySQL or MSSQL where DDL cannot be rolled back automatically. Constraints: Knex only records a migration after its up promise resolves, so a mid‑file failure leaves the schema ahead of the knex_migrations entry and does not invoke the down function; recovery therefore depends on external backups