Make table view not working ?

[OlivierOlivier]

Hi,

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 !

Olivier
ArcEditor 9.3.1

[OlivierOlivier]

Doing more tests, I think that "Make table view" got a bug.

How to reproduce :

Connect directly the output to Make XY Event Layer (as an example) to generates an XY subset, Make table view send the whole table to the output, even if you add a filter like X <> X, which obviously return nothing.

The workaround I found is to insert "copy rows" between "make table view" and XY event. In this case, the output table is correct and can be an input for XY Event.

But it's not finish !!

The problem now is that the output of "Make XY Event layer" with "Copy rows" input can't be merged with another shapefile using the merge toolbox, as it's considered as a table and note a shapefile. (cannot merge table and features classes message)
I tried to insert "merge" or "copy" or even both to generate a shapefile that will be an acceptable input for another merge. A shapefile is generated but is not allowed to be merged with another shapefile as still considered as a table. (see image)

I searched some other geoprocessing tool to convert layer to shapefile but didn't find. I thought that Feature Class to shapefile was the solution but the its output can't be connected to merge... why ?

Thanks for any help

[OlivierOlivier]

Here is the (stupid) solution I found, Generate a shapefile, add a precondition to use this shapefile thru another variable. Not possible to link directly....

What is surprising it that the output of merge(2) is a .dbf, but it generates a shapefile.

Hope someone will help me to understand if I'm wrong somewhere, or if it's possible that I got there different geoprocessing bugs.

MAKE TABLE LAYER not filtering, MERGE exporting shapefiles with "table type" when COPY ROWS as input and finally MAKE TABLE LAYER output database field loosing whole path after closing toolbox.