joldekop

Problem Executing arcpy.Select_analysis

Discussion created by joldekop on Sep 22, 2011
Latest reply on Sep 22, 2011 by joldekop
Hi,

currently trying to learn Python to do some scripting but unfortunately I keep getting an error message. Below are the scripts I have used, followed by the actual Error Message:

# Import system modules
import arcpy
from arcpy import env

# Set workspace
env.workspace = "C:/GTZ Data/PEN_IUCN/PEN_IUCN"

# Set local variables
in_features = "AMPHANURA_RBS_Clip"
out_feature_class = "C:/IUCN Data/AMPHANURA/AMPHANURA_RBS_Clip_FID3.shp"
where_clause = '"FID" = \'3\''

# Execute Select
arcpy.Select_analysis(in_features, out_feature_class, where_clause)

AS WELL AS

# Import system modules
import arcpy
from arcpy import env

# Set workspace
env.workspace = "C:/GTZ Data/PEN_IUCN/PEN_IUCN"

# Set local variables
in_features = "C:/IUCN Data/AMPHANURA/AMPHANURA_RBS_Clip.shp"
out_feature_class = "C:/IUCN Data/AMPHANURA/AMPHANURA_RBS_Clip_FID3.shp"
where_clause = '"FID" = \'3\''

# Execute Select
arcpy.Select_analysis(in_features, out_feature_class, where_clause)

Runtime error <class 'arcgisscripting.ExecuteError'>: ERROR 999999: Error executing function. An invalid SQL statement was used. An invalid SQL statement was used. Failed to execute (Select).

Any ideas?

thanks a lot...

Johan

Outcomes