Spatial Query Layers used to create Customer and Store layers crash Business Anlayst 10.
上次发布: August 25, 2014ArcGIS 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.