How can i get a schema via ODBC? ( maybe offtopic )

Posted in 1998

Klaus Weitzer — Tue, 25 Aug 1998 11:44:33 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi to all possible helpers! Target: I want to write a class in C++/VisualBasic on NT which displays the needed data in a grid, but does inserts/updates/selects automaticaly even if there are joins. ( btw: updateable views would be appreciated ) First thought: Get all tables/columns concerned for display and then create all references by reading constraints/references from the DB ( Domainvalues as well ) Problem: How do i get the information? In VB ( RDO ) the table/column PK's are no problem but there is no way to determine the FK or related information. Any suggestions would be wellcomed Kind regards Klaus Weitzer Vienna PS.: Sorry for my lousy english