thanks , I try your solution but i've got the same message :
Traceback (most recent call last):
File "C:/Users/d.rouffart/Desktop/script Py/gxdh.py", line 69, in <module>
arcpy.SelectLayerByAttribute_management(i + "_lyr", 'NEW_SELECTION', whereclause)
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 9574, in SelectLayerByAttribute
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 9571, in SelectLayerByAttribute
retval = convertArcObjectToPythonObject(gp.SelectLayerByAttribute_management(*gp_fixargs((in_layer_or_view, selection_type, where_clause, invert_where_clause), True)))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 511, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 000358: Invalid expression
Échec de l’exécution de (SelectLayerByAttribute).
but when i think my expression is good