IBX Tip: Use the Schema Cache
I needed to know the primary key of a table for some code I was writing. Simple enough to get the information from the system tables, but this code would be called quite frequently, so I thought I would need to cache the information. Then I realized that IBX already does this. Look at TIBDatabase.In_Key. Saved me from reinventing the wheel.