Latest Contributions by Bud

Edited.   It seems there is a bug in ArcGIS Pro 3.0.3. I tried to repeat my steps, but I got the same error you did when adding the view to the map: Failed to add data, unsupported data type. An invalid SQL statement was used.   Workaround: Create the tables in a FGDB, but then copy the tables to a new FGDB (using right-click copy/paste in Catalog). In the new FGDB, I'm able to create the view, add the view to the map, and open the attribute table. Does that workaround work for you?   Note: The bug doesn't appear to be specific to the INNER JOIN view we're testing. I got the same error when creating a simpler view:  select     * from     table_a   Related: Bug: View on FGDB standalone table — can't add view to map ... View more

@JoshuaBixby  Meanwhile, SQL joins appear to be supported in FGDB views: select * from table_a a inner join table_b b on a.id_a = b.id_b ArcGIS Pro 3.0.3 ... View more

I like this idea too. I'm commenting, instead of upvoting, since the upvote button is currently disabled. Related: Kudo an idea that is flagged as Needs Clarification ... View more

@MarceloMarques  It’s my understanding that the only thing that our DBA needs to do is run the following statement using a connection to NON_IT_USER1: GRANT SELECT ON NON_IT_USER1.FC1 TO NON_IT_USER2 WITH GRANT OPTION; I don’t think I understand why that can’t be done though ArcGIS Pro. I worked in IT previously, and often ran statements like GRANT SELECT ON NON_IT_USER1.FC1 TO IT_USER WITH GRANT OPTION; Are you suggesting the DBA had to do a one-time operation to allow NON_IT_USER1 to run GRANT SELECT ON … WITH GRANT OPTION for all tables in that owner — going forward? In other words, are you saying the DBA needs to perform a generic step before a user can GRANT SELECT ON … WITH GRANT OPTION? If so, could Esri add a “Grant [other users to create views]” column to the Privileges window in Pro, and just grey-out the checkboxes if the DBA hasn’t performed the prerequisite step yet? None of this data is sensitive. There are no security concerns about these grants. It’s just a nuisance more than anything. ... View more

What happens if you put a line break in the text using CTRL+Enter or something like that? ... View more

@SSWoodward  Regarding, SQL for reporting and analysis on file geodatabases, I don’t think these SQL keywords work in FGDB definition queries/subqueries: CASE COALESCE JOIN NULLIF ORDER BY   Here’s an example of something I want to do in a FGDB definition query, but can’t, due to FGDB SQL limitations: https://community.esri.com/t5/arcgis-pro-ideas/one-to-first-joins-control-what-related-record-is/idc-p/1239993/highlight/true#M22488 Works for SQLite/mobile geodatabases, but not file geodatabases: roadinsptable.objectid IN ( SELECT objectid FROM roadinsptable r2 WHERE r2.asset_id = roadinsptable.asset_id ORDER BY date_ DESC, condition DESC LIMIT 1 ) I’m aware that FGDB SQL doesn’t have LIMIT, not even in the FGDB API. There are likely other ways to accomplish it using SQL, without LIMIT, in databases that have full SQL support. But those alternatives wouldn’t be possible in FGDB definition queries due to the limited FGDB SQL.   Part of the problem is that I’m not actually sure if  SQL for reporting and analysis on file geodatabases actually pertains to the FGDB API. It’s a confusing page in a confusing place with no context.   Edit: Here's another example of the useful stuff we can do in geodatabases like enterprise and mobile, but not in file geodatabases: Force bar chart to show missing years within 10-year range (system year + 9). The queries generate filler rows so that there are rows/bars for each year in the 10-year range.     ... View more

I wonder how ThomasColson’s technique would work for Oracle geodatabases, since the DEFINITION column is stored as a CLOB, not text (but available as text in a view). I guess we could just convert our modified XML to a CLOB using an SQL query, then use SQL to UPDATE the table value? ... View more

As a token of appreciation for the thousands of hours these kind people have spent helping Esri customers, could Esri do something like offer the MVPs free Esri software? Something significant, such as a free ArcGIS Developer license, which is otherwise unaffordable for personal use. Idea: Thank MVPs by giving them ArcGIS Developer license ... View more