Make table view not working ?

Discussion created by olivier57 on Nov 29, 2010
Latest reply on Dec 3, 2010 by olivier57

I am trying to get a subset of a table using "make table view" (see attached model).

The problem is that I can set any SQL query in expression field, the whole original table is always the result of "make table view". As an example, I can write [NAME] = 'not existing name', which return no result.  If I check "verify result" for the SQL query and get the answer "The expression was successfully verified but no records where returned", I still get the original table.

You'll see in the joined example that I'm trying to filter the table to create a new layer using X,Y fields. In fact, the result is the complete original table.

Thanks for any help, I'm getting mad with it !

ArcEditor 9.3.1