POST
|
Thanks, Andres For the screen shot above, the SQL was something like: select tableName.current_period AS [CURRENT PERIOD], Originally, the query didn't even have the "AS" in there and it worked fine, but that no longer works and I haven't been able to determine what has changed. Now, what you see in the square brackets is treated as both the field name and the alias. Spaces and special characters aren't allowed in field names, but they are acceptable in the alias. As a work around, I've stripped the aliases from the SQL when creating the view in ArcCatalog and I've created a model builder model to use the Alter Field tool to add the aliases after the fact. It's an extra step that allows the original spaces and special characters we've always had in our field aliases, but I'd prefer to return to including the aliases in the view definition. New work flow is as follows - Create db view in ArcCatalog without alias designations in sql Register view w/ db Add the field aliases via model builder Hoping to eliminate that last step we've recently had to add to the process.
... View more
10-24-2018
12:56 PM
|
0
|
1
|
1137
|
POST
|
Hi, I’ve tried that and it hasn’t worked but I will try again. I noticed something else yesterday, too. When trying to include the alias, ArcCatalog is taking what I think I’ve configured correctly as an alias and using it as the actual field name. As you can imagine, that’s causing problems because what I’m writing as aliases have spaces and special characters.
... View more
10-24-2018
08:24 AM
|
0
|
0
|
1137
|
POST
|
The data is stored in Microsoft SQL Server. The query tested in Microsoft Management Studio is valid, but ArcCatalog and ArcMap are no longer tolerating the spaces and special characters in the aliases. ArcGIS & ArcCatalog 10.5 Microsoft SQL Server 2017 I do have ArcGIS & ArcCatalog 10.6 on another VM... haven't tried there. I also have a support ticket. Thought I'd see if the community had some ideas, too.
... View more
10-23-2018
12:09 PM
|
1
|
5
|
1464
|
Title | Kudos | Posted |
---|---|---|
1 | 10-23-2018 12:09 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:25 AM
|