Bogue
Spatial Query Layers used to create Customer and Store layers crash Business Anlayst 10.
| Numéro d’ID de bogue | NIM061817 |
|---|---|
| Envoi | October 7, 2010 |
| Dernière modification | June 5, 2024 |
| S’applique à | ArcGIS for Desktop |
| Version trouvée | 10.0 |
| Système d’exploitation | Windows OS |
| Version du système d’exploitation | XP |
| Version de correction | 10.0 |
| Statut | Fixed |
Solution de contournement
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.Étapes pour reproduire
ID de bogue: NIM061817
Logiciel:
- ArcGIS for Desktop
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support