Select to view content in your preferred language

More descriptive FGDB SQL errors

207
0
01-16-2024 01:31 PM
Status: Open
Labels (1)
Bud
by
Esteemed Contributor

ArcGIS Pro 3.2.1; file geodatabase

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:

ERROR 160195: An invalid SQL statement was used.

Bud_2-1705440617531.png

select
    *
from
    species_records
where
    cast(t_date as char(50)) is not null 


Could the FGDB SQL engine be improved so that it feeds more specific error messages to tools like Create Database View?