Lookup foreign keys in Interbase/Firebird

Submitted by Frederic Marand on

The Paradox form system has an interesting peculiarity: any field which happens to be constrained by a foreign key within a native .DB Paradox data model automatically gets lookup values available for the user, but this is not available other database formats, whether they be natively supported within the BDE, or accessed using ODBC, so lookups have to be added in code.

Paradox formatted memos in Delphi applications

Submitted by Frederic Marand on

Earlier today, someone asked how to display the contents of Paradox formatted memo fields in a Delphi app.

I setup a basic solution, for which the source is given hereunder.

The idea is to define a calculated String field for the Query or Database used. Say be call it FMT in a table TBL, so its object name will be TBLFMT. In the OnGetText event for the field, add this code: