idea More descriptive FGDB SQL errors in ArcGIS Pro Ideas https://community.esri.com/t5/arcgis-pro-ideas/more-descriptive-fgdb-sql-errors/idi-p/1370726 <P><EM>ArcGIS Pro 3.2.1; file geodatabase</EM></P><P>When I get an FGDB error, such as when creating a database view, it seems like the error message is always the same no matter what the underlying issue is:</P><PRE>ERROR 160195: An invalid SQL statement was used.</PRE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_2-1705440617531.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/91758iE4E998E05AD17ED3/image-size/large?v=v2&amp;px=999" role="button" title="Bud_2-1705440617531.png" alt="Bud_2-1705440617531.png" /></span></P><PRE>select * from species_records where cast(t_date as char(50)) is not null </PRE><P><BR />Could the FGDB SQL engine be improved so that it feeds more specific error messages to tools like Create Database View?</P><P>&nbsp;</P> Wed, 17 Jan 2024 03:34:24 GMT Bud 2024-01-17T03:34:24Z More descriptive FGDB SQL errors https://community.esri.com/t5/arcgis-pro-ideas/more-descriptive-fgdb-sql-errors/idi-p/1370726 <P><EM>ArcGIS Pro 3.2.1; file geodatabase</EM></P><P>When I get an FGDB error, such as when creating a database view, it seems like the error message is always the same no matter what the underlying issue is:</P><PRE>ERROR 160195: An invalid SQL statement was used.</PRE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_2-1705440617531.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/91758iE4E998E05AD17ED3/image-size/large?v=v2&amp;px=999" role="button" title="Bud_2-1705440617531.png" alt="Bud_2-1705440617531.png" /></span></P><PRE>select * from species_records where cast(t_date as char(50)) is not null </PRE><P><BR />Could the FGDB SQL engine be improved so that it feeds more specific error messages to tools like Create Database View?</P><P>&nbsp;</P> Wed, 17 Jan 2024 03:34:24 GMT https://community.esri.com/t5/arcgis-pro-ideas/more-descriptive-fgdb-sql-errors/idi-p/1370726 Bud 2024-01-17T03:34:24Z