Master-Detail Forms in Delphi: Invoice Header and Invoice Lines (FireDAC)
Build the most common ERP screen, an invoice with header and lines, using Delphi master-detail datasets, an item lookup, calculated line totals and an invoice total.
Build the most common ERP screen, an invoice with header and lines, using Delphi master-detail datasets, an item lookup, calculated line totals and an invoice total.
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.
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.
Show SQL Server data in a Delphi DBGrid with FireDAC: query, data source and grid, columns, search, sorting, editing, totals and FetchOptions.
Use parameters in Delphi SQL queries with FireDAC and ADO: ParamByName, data types, NULLs, dates, LIKE, INSERT, and how they stop SQL injection.
Connect Delphi to SQL Server with FireDAC: TFDConnection settings, Windows vs SQL login, connecting in code, the ADO alternative and common errors.