Lookup Combo Boxes in Delphi: Choose a Customer or Item From a List
Let users pick a customer or item by name while the database stores the ID: TDBLookupComboBox, lookup fields in a DBGrid, search dialogs and common traps.
Let users pick a customer or item by name while the database stores the ID: TDBLookupComboBox, lookup fields in a DBGrid, search dialogs and common traps.
Build a complete customer maintenance screen in Delphi for SQL Server: grid, edit fields, search, defaults, validation and friendly errors, mostly with no code.
How to find the one slow statement inside a SQL Server stored procedure, and fix the eight usual causes: parameter sniffing, catch-all queries, loops, scalar functions, table variables, implicit conversions, local variables and waits.
Gaps and islands in SQL: find missing invoice numbers with LEAD, consecutive ranges and login streaks with the ROW_NUMBER trick, runs of the same status with LAG and a running SUM, and missing dates with a calendar.
Delphi, C# (.NET) or a web app for ERP and business software? A fair side-by-side comparison, the same task in all three, and a simple guide to choose.
Why “Execution Timeout Expired” comes from the application, not SQL Server: how to find timed-out queries in Query Store and Extended Events, the five usual causes, and why SET XACT_ABORT ON matters.
How to find duplicate rows in SQL with GROUP BY and HAVING, see the full rows behind them, keep one copy with ROW_NUMBER, delete the rest safely in SQL Server and MySQL, and stop duplicates coming back.
Import a CSV file into SQL Server from Delphi: parse lines, load a staging table, fast FireDAC Array DML, BULK INSERT, and report bad rows.
How to insert a row if it is new and update it if it exists: the race condition in IF EXISTS, safe single-row and whole-table upserts, MERGE and its traps, and INSERT … ON DUPLICATE KEY UPDATE in MySQL.
Show SQL Server data in a Delphi DBGrid with FireDAC: query, data source and grid, columns, search, sorting, editing, totals and FetchOptions.