I am trying to use a "Where" clause for the reader but it does not identify the field in the existing geodatabase.
I have a Esri Geodatabase connection named vg_esri and I wanted to select a table named vg_esri.sde.mm_poly_gh and select a polygon wíth its id polygon_id = 852364, I have used
SELECT polygon_id FROM vg_esri.sde.mm_poly_gh WHERE polygon_id = '852364';
Could not find the features in the table 'sde.mm_poly_gh'. One possible reason is that a WHERE clause was specified that references a column/field that does not exist in the table. The error number from ArcObjects is: '-2147216081'. The error message from ArcObjects is: {Invalid SQL syntax fERROR: syntax error at or near ";"
LINE 1: ...FROM dg_esri.sde.mm_poly_gh WHERE polygon_id = '852364';)
But I get this above error, What am I doing wrong, I cannot figure it out. Any input will be very help. Thank you...