隱藏目錄

List Dialog Box

Use the List dialog box to maintain and update list values for data-card lists or selection boxes without needing to modify the list values in each card individually.

To display this dialog box:

Right-click Lists and select Add New.

List name  
Data type Select if the list should show static Text values or From SQL database.

Data Type - Text

For a text list, under Data, enter values for the list, one value per row.

Data Type - From SQL Database

When you select From SQL Database as the Data type, you fill in the SQL query and connection information used to access the external database.

SQL command Enter the T-SQL query that selects lists values from a database table.

In this example, the query will return a list of companies from the Suppliers table in the sample SQL database Northwind.

Select Companyname

From Suppliers

Order by Companyname

Server IP or name of a SQL server hosting the database.
Database Name of SQL database containing the list values.
Login SQL user name that can access the database table using the query.
Password Password for the SQL user.
Refresh If the SQL list should be periodically updated, select when the specified query should run to refresh the list values.

Options are:

  • Refresh when the following registry key is created

    Specify a registry value on the SQL server running the Enterprise PDM database that should trigger a refresh if changed. The value is checked every minute and if it has changed, the SQL query runs and refreshes the list. Make sure to supply the full key name and value, for example:

    HKEY_LOCAL_MACHINE\SOFTWARE\SOLIDWORKS\Applications\PDMWorks Enterprise\ListUpdate\Update

  • Periodic refresh every

    Specify the refresh interval in minutes. The minimum value is 1 (minute).

Data Type - Text with Alias

Under Data:

Data
  • Displayed Value

    The value that is displayed in the data card.

  • Alias

    The alias that is store in the file and database.

If you have a spread sheet or document that contains a set of displayed values and aliases, you can copy it, click under Displayed Value, and paste it into the Text with Alias list.



提供對此主題的意見反應

SOLIDWORKS 歡迎您提供有關於文件呈現方式、正確性、及完整性的意見反應。請使用下方的表格直接將您對此主題的意見與建議傳送給我們的文件團隊。文件團隊並無法回答關於技術支援的問題。按一下此處來獲得關於技術支援的資訊

* 必要的

 
*電子郵件:  
主旨:   說明主題的意見反應
頁面:   List Dialog Box
*意見:  
*   我承認已閱讀且僅此接受隱私權政策,Dassault Systèmes 將遵循此政策之規定使用我的個人資料

列印主題

選擇要列印的內容範圍:

x

偵測到您使用的瀏覽器版本是舊於 Internet Explorer 7。要獲得最佳的顯示,建議您升級瀏覽器到 Internet Explorer 7 或更新的版本。

 不要再次顯示此訊息
x

Web 式說明內容版本:SOLIDWORKS PDM 2014 SP05

要從 SOLIDWORKS 中停用 Web 式的說明並改用本機說明,請按一下說明 > 使用 SOLIDWORKS Web 式說明

要報告在 Web 式說明介面及搜尋中遇到的問題,請聯絡您當地的技術支援代表。要針對個別說明主題提供意見反應,請使用個別主題頁面中的「提供對此主題的意見反應」連結。