如何去抓一個access檔案裡所有的table name啊? |
答題得分者是:GaryKao99
|
dbstudio
一般會員 發表:13 回覆:18 積分:6 註冊:2003-12-07 發送簡訊給我 |
請問一下,我現在在練習寫BCB中有關資料庫的程式,因為是新手,
希望大家多多包含:)
世這樣的,我現在寫了一個程式可以讓使用者任意選取一個*.mdb的ACCESS檔案,
請問一下我要如何把這個我選的*.mdb的檔案中的所有relation name都抓出來呢? 譬如說:
一個COMPANY中有以下的RELATION TABLE:
Employee
Department
Projext等... 要如何才能把這些table的NAME找出來啊?:) 哇錦喊嫚公為
膽喜挖金喜災
蓋小哩厚有
------
哇錦喊嫚公為 膽喜挖金喜災 蓋小哩厚有 |
GaryKao99
中階會員 發表:46 回覆:102 積分:54 註冊:2002-08-23 發送簡訊給我 |
TADOConnection::GetTableNames Populates a string list with the names of tables in the database. void __fastcall GetTableNames(Classes::TStrings* List, bool SystemTables); Description Call GetTableNames to retrieve a list of tables in the associated database. List is the already-existing string list object into which the tables names are put. Set SystemTables to indicate whether the list of table names should include the databases system tables. ADOConnection1->GetTableNames(ListBox2->Items, false); Note: Any contents already in the target string list object are eliminated and overwritten by the data produces by GetTableNames.
|
dbstudio
一般會員 發表:13 回覆:18 積分:6 註冊:2003-12-07 發送簡訊給我 |
引言: TADOConnection::GetTableNames Populates a string list with the names of tables in the database. void __fastcall GetTableNames(Classes::TStrings* List, bool SystemTables); Description Call GetTableNames to retrieve a list of tables in the associated database. List is the already-existing string list object into which the tables names are put. Set SystemTables to indicate whether the list of table names should include the databases system tables. ADOConnection1->GetTableNames(ListBox2->Items, false); Note: Any contents already in the target string list object are eliminated and overwritten by the data produces by GetTableNames.都謝篩 哇錦喊嫚公為 膽喜挖金喜災 蓋小哩厚有
------
哇錦喊嫚公為 膽喜挖金喜災 蓋小哩厚有 |
本站聲明 |
1. 本論壇為無營利行為之開放平台,所有文章都是由網友自行張貼,如牽涉到法律糾紛一切與本站無關。 2. 假如網友發表之內容涉及侵權,而損及您的利益,請立即通知版主刪除。 3. 請勿批評中華民國元首及政府或批評各政黨,是藍是綠本站無權干涉,但這裡不是政治性論壇! |