Create a new DB to hold this kind of data (let's call it system level tables) and attach it to the main db. Thus you can join the city table with the phone calls or whatsoever.
When using db-aware controls, the first thing I'd consider is to use Dataset (Lookup).Easiest one: TBuffDataset stored in XML.Another option (if you need a display in Grid only) - DBGrid's Picklists.
Quote from: garlar27 on February 11, 2020, 03:08:23 pmCreate a new DB to hold this kind of data (let's call it system level tables) and attach it to the main db. Thus you can join the city table with the phone calls or whatsoever.This sounds intriguing! How is it possible to attach one DB to another?Can you please provide a bit more detailes or links?
Thanks, garlar. I didn't find description of similar construction for Informix. And I guess this will break the rule: "Do not modify DB structure".