VFP 愛用者社區

cool · 註冊時間: 2003-05-17 文章: 47 第 1 樓

請問在 VFP 8.0 的 MODI STRU 時, 索引類型為何找不到 UNIQUE 的類型, 若要用 UNIQUE 要如何做呢?

syntech · 發表於: 星期一二月 28, 2005 10:08 am 文章主題:

Visual FoxPro 8.0 Language Reference

INDEX Command
Creates an index file to display and access table records in a logical order.

INDEX ON eExpression TO IDXFileName | TAG TagName
[ COLLATE cCollateSequence ] [OF CDXFileName] [FOR lExpression]
[COMPACT] [ASCENDING | DESCENDING] [UNIQUE | CANDIDATE] [ADDITIVE]

cool · 註冊時間: 2003-05-17 文章: 47 第 3 樓

謝謝 SYNTECT 的指教
可是只能用命令的方式完成嗎?
如果在 MODI STRU 下的資料表格設計工具中要如何操作呢?
在 VFP6 的版本中是可以的.

syntech · 發表於: 星期二三月 01, 2005 5:14 pm 文章主題:

在 vfp 8 online help 有這麼一句:

Indexes Tab, Table Designer
--------------
Type
Specifies the type of index: Primary (only if the table is contained in a database), Candidate, or Regular (the default). When you click a cell in this column, a list appears from which you can select a type. An entry is not required in this field.
Only one index in a table can be set as Primary in the Type column.

Note If a table contains a unique index tag, the Table Designer will list that type, but the designer no longer provides this tag option.

-------------
乖乖的用命令吧! Smile