Getting info from a database

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by danid Tue, 13 Sep 2005 08:53

#531

Author: danid
Date: Tue, 13 Sep 2005 08:53

8 lines
1188 bytes


  Hello,

I am using TADOQuery to retreive the table names (GetTableNames())and field names (GetFieldNames())of a table in a database. 
How can I get a list of the foreign keys in a table, and to which table they belong (parent, child)? 
I am using BCB6 with an MS Access database.
Thanks a lot,

Re: Getting info from a database

#532

Author: Viatcheslav V. Vassiliev
Date: Tue, 13 Sep 2005 20:33

22 lines
1768 bytes

Use TADOConnection::OpenSchema with siForeignKeys.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"danid" <danid@nospam.com> �������/�������� � �������� ���������: 
news:43269385$1@newsgroups.borland.com...
>
>
>  Hello,
>
> I am using TADOQuery to retreive the table names (GetTableNames())and 
> field names (GetFieldNames())of a table in a database.
> How can I get a list of the foreign keys in a table, and to which table 
> they belong (parent, child)?
> I am using BCB6 with an MS Access database.
> Thanks a lot,

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads