I have to make an SQL query on a column having not adequat name "type_borne_id", I couldn't make SQL queries using arcpy.Select_analysis neither selectbyattribute, but when I use select_analysis toolbox in arcmap it works with the same column.
I wonder if I should add some characters, or what to do, to query this column normally? I remarked that this pattern of names "name_column_id" is vulnerable to this error.
Example of the queries that didn't work:
arcpy.Select_analysis("table" , "table_copy" , " type_borne_id = 23" )arcpy.Select_analysis("table" , "table_copy" , ' "type_borne_id" = 23' )
I have tested with other fields like "id" and it works normally.
I'm using Arcgis 10.1 & ArcSDE 10.1 on PostgreSQL.
أكثر...
I wonder if I should add some characters, or what to do, to query this column normally? I remarked that this pattern of names "name_column_id" is vulnerable to this error.
Example of the queries that didn't work:
arcpy.Select_analysis("table" , "table_copy" , " type_borne_id = 23" )arcpy.Select_analysis("table" , "table_copy" , ' "type_borne_id" = 23' )
I have tested with other fields like "id" and it works normally.
I'm using Arcgis 10.1 & ArcSDE 10.1 on PostgreSQL.
أكثر...