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.
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.
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.
Delphi exception handling explained: try..except vs try..finally, catching specific exceptions, raise and re-raise, custom exceptions, FireDAC errors.
OOP in Delphi for beginners: classes, objects, properties, constructors, try..finally with Free, inheritance, virtual methods and TObjectList.
Use parameters in Delphi SQL queries with FireDAC and ADO: ParamByName, data types, NULLs, dates, LIKE, INSERT, and how they stop SQL injection.
Split Delphi code into procedures, functions and units: value, const, var and out parameters, default parameters, overloads and the unit structure.
Connect Delphi to SQL Server with FireDAC: TFDConnection settings, Windows vs SQL login, connecting in code, the ADO alternative and common errors.