I have created a Feature layer and I want to do a SQL select on the feature layer. To accomplish this I have converted the feature layer to a table using the Create Table tool. Now I am attempting to carry out a SQL select on that table using the Table Select tool.
The problem is that when I go to build the SQL expression, the fields contain no values and are blank, yet in the feature layer the fields contain values.
Solved! Go to Solution.
It is like it exists... briefly, but use Delete when done to be safe
According to Table Select it supports
The input can be an INFO, dBASE, or geodatabase table, a feature class, table view, or VPF dataset.
Do you mean a feature layer ? or feature class?
It is a Feature Layer.
I am trying to select certain records from the feature layer, is there another way to do this without converting to a table?
Why not do it in_memory if you don't want to create a physical table on disk... you can dump it when you are done with it if you are doing this in a script or modelbuilder
doing in model builder but I havent a clue about In_memory
It is like it exists... briefly, but use Delete when done to be safe
Thanks Dan