Latest Contributions by Bud

If I try to create a definition query that has invalid syntax, ArcGIS Pro displays a generic error message: The SQL expression has invalid syntax. That generic error message isn't very helpful. The database is likely throwing a more descriptive error message behind the scenes: ORA-00942: table or view does not exist 00942. 00000 - "table or view does not exist" *Cause: *Action: Error at Line: 5 Column: 13 SQL Developer: Could ArcGIS Pro be enhanced so that the more descriptive database error messages are displayed in the definition query window? That would help with debugging. Thanks. ArcGIS Pro 2.6.8; Oracle 18c 10.7.1 enterprise geodatabase and ArcGIS Pro 3.0.3; mobile geodatabase   ... View more

@KoryKramer Feel free to close this idea. Support is submitting bug reports for these issues.   Edited: I removed the part about hovering over the definition query. Regarding the definition query window: For an existing definition query that is enabled, the toggle makes it look like it's disabled. GIF: Could the UI be improved so that it's clear that an existing enabled definition query is displayed as being enabled?  Thanks.   ArcGIS Pro 3.0.3; mobile geodatabase. ... View more

Edited When creating feature layers using ArcPy: There doesn’t seem to be a way to Vary symbology by rotation using ArcPy. Could that functionality be added? Related: ArcPy script to convert layer to individual feature layers for each symbology class https://community.esri.com/t5/arcgis-pro-sdk-questions/customize-pro-ui-checkboxes-in-toc-to-toggle/m-p/1239558/highlight/true#M9159 ... View more

When creating an idea in a community where the idea label is mandatory: I might leave the label text box blank at first, either accidentally or on purpose, and start to write the body first instead. When I do that, after a few seconds of typing in the body, the page will automatically scroll up to the blank text box, and change the cursor’s focus. I assume it does that to encourage me to fill in the mandatory label. But it’s quite aggravating when that happens. A page shouldn’t automatically scroll around like that while you’re typing. It makes for a negative user experience, to say the least. Could that behaviour be changed? Thanks.   Google Chrome. ... View more

I've created a mobile geodatabase using ArcGIS Pro 3.0.3. What version of SQLite is the .geodatabase file? For example, is it SQLite 3.39? Thanks. ... View more

How can I open a mobile geodatabase file using VSCode? Here's what I tried: I've created a mobile geodatabase using ArcGIS Pro 3.0.3: I've added an extension to VSCode 1.74.0 called vscode-sqlite: https://marketplace.visualstudio.com/items?itemName=alexcvzz.vscode-sqlite In VSCode, I use CTRL+Shift+P to open the textbox at the top. Choose SQLite: Open Database >> Choose database from file. Browse to the folder that my mobile geodatabase is in. Problem: No files are listed; I can't see/open the mobile geodatabase. I assume VSCode can't see my mobile geodatabase because it's file extension is .geodatabase, not the usual .db extension for SQLite databases.   How can I open a mobile geodatabase using VSCode? Related: What SQL client do you recommend for querying mobile geodatabases? ... View more

ArcGIS Pro 3.0.3 mobile geodatabase: It would be helpful if the SQLite database version number could be displayed in the database properties: For example, what SQLite version is that database? 3.39? Or something else? Granted, SQLite version numbers are complicated. See: Mobile geodatabase created by ArcGIS Pro 3.0.3 — What SQLite version is the .geodatabase file? But there's got to be some sort of version number information that can be displayed that would be useful to the user. Thanks. ... View more

The Add Join tool should warn the user if the join table has a definition query, since the definition query will be applied to the join. For example, if we're using a map that someone else created, we might not be aware that the join table has a definition query. And so the definition query would be applied unknowingly. Edit: I suppose the GP tool could be enhanced so that the definition query is shown as an editable SQL expression text box right in the tool. We’d have the option of changing the definition query or removing it, if needed (in the join, not the underlying table). Or we could even add a new definition query, if there wasn’t one already. That would have the added benefit of making it abundantly clear that there is a definition query. It would be hard to ignore. Whereas a small yellow exclamation mark beside a field is easy to accidentally overlook, especially when we see those exclamation points regularly for things like “no index” warnings. ArcGIS Pro 3.0.3 ... View more

ArcGIS Pro 3.0.3; mobile geodatabase: I have a FC and a standalone table: I apply a definition query to the table -- to pare-down the rows so that only the latest inspection per asset is shown: date_ = (select max(subq.date_) from roadinsptable subq where roadinsptable.asset_id = subq.asset_id) I create a join from the FC to the table: The join works as expected. And the definition query from the table is honoured.   Later, I change my mind: I've determined I don't need the join, so I remove it: Problem: Removing the join causes an error: Failed to open table.  Error: Attribute column not found [no such column: date_] [Roads][STATE_ID = 0] I hit OK. The attribute table of the FC automatically closes. I try to re-open the attribute table of the FC: But I get the same error I saw previously. And the attribute table doesn't open. Trying again produces the same error.   The only way to successfully open the attribute table again is to remove the FC from the map and re-add it, which isn’t ideal. Is that a known issue? I only have the problem when the join table has a definition query. If there's no definition query, then I can remove the join without getting the error. ... View more

ArcGIS Pro 3.0.3; mobile geodatabase. When creating a join via Add Join: For cases where the join table has duplicate rows, it would be helpful if we could choose whether the join will be one-to-first (1:1) or 1:M. Result: Can an option be added to Add Join to explicitly choose either one-to-first or 1:M? Related: Join — Control what related record gets used ... View more

ArcGIS Pro 3.0.3; mobile geodatabase: I want to create a new standalone table. When creating the table, I want to import the schema from an existing FC called main.RoadInsp. main.RoadInsp FC:   In Create Table, I click Import and browse to the mobile geodatabase. Problem: I don't see the FC listed, so I can't use it's schema when creating the table. Could that behavior be changed so that I can use the FC's schema when creating a table? Thanks. ... View more

In ArcGIS Pro 3.0.3, I have a mobile geodatabase view that I've deleted. When I refresh the mobile geodatabase in Catalog, the deleted view reappears. I've tried re-deleting the view several times and closing/re-opening ArcGIS Pro. Same result each time; the view reappears. Is that a known issue? ... View more

When using Safari on my iPad to use the Esri community: When I’m on my profile page, the search bar is not visible. If I tap where the search bar would be, nothing happens; the keyboard doesn’t pop up because a text box has not been clicked. So I’m unable to search my posts directly from my profile. I can click the magnifying glass button which will do a blank search of my profile. And I can refine the search on the resulting page without issue. But that’s just a workaround. I’d rather search directly from my profile. Could that issue be investigated? Thanks. iOS 15.6.1 ... View more