laptop and a wrench

漏洞

Spatial Query Layers used to create Customer and Store layers crash Business Anlayst 10.

上次发布: August 25, 2014 ArcGIS for Desktop
漏洞 ID 编号 NIM061817
已提交October 7, 2010
上次修改时间June 5, 2024
适用范围ArcGIS for Desktop
找到的版本10.0
操作系统Windows OS
操作系统版本XP
修正版本10.0
状态Fixed

解决办法

Option 1-----------Make a query layer of tabular data stored in the SQL Server database and use the tabular (addresses) or xy/gps (latitude/longitude coordinates) methods to create store and customer layers.Option 2----------Create a query table with the Make Query Table tool in ArcToolbox > Data Management Tools > Layers and Table Views and use it as the input for the store and customer setup using the tabular or xy/gps method.a. Make an OLE DB connection to the SQL Server database in ArcCatalogb. Launch the Make Query Table toolc. Add the customer table from the OLE DB connectiond. Select all of the necessary fieldse. Specify the SQL expression to create a subset of the 9 million customersf. Specify a name for the query tableg. Specify a Key field, either the ObjectID or some other field or a Virtual KeyFieldh. Click Ok to run the tooli. Use the new query table as the input to the Customer or Store setup.

重现步骤

漏洞 ID: NIM061817

软件:

  • ArcGIS for Desktop

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项