[ic] can't make the inactive/HIDE_FIELD work with 4.9.6

[NOW Website Coordinator]

I've read the mailing list and WHATSNEW, but I can't seem to make the 
inactive field work properly in 4.9.6 (trying to upgrade from 4.8.6)

I've added these lines to catalog.cfg:

Database products products.txt TAB
Database products HIDE_FIELD inactive
Database products COLUMN_DEF "inactive=int default 0"

I'm using the default database type,  although I don't see a way to design 
it to be an integer type field-- I assume that's for other database 
types.  Are there other configurations I'm missing?  Or does it need to be 
an SQL database?

It says it should work via search and NOT query.  I'm testing it with the 
search box and advanced search and a record I've marked still shows up.  By 
the way, what exactly does it mean not to work with "query"?

Thanks for your help.

Here is what it says in WHATSNEW:



* Add new HIDE_FIELD capability to DbSearch. It provides automatic
   hiding of records accessed via search (and NOT query).

  -When the following configuration is added:

     Database products HIDE_FIELD inactive

  -It adds automatically the qualification to every search:

     WHERE inactive != 1

  -To use, you should have a field of char(1) or int type.

     Database products COLUMN_DEF "inactive=int default 0"

  -This has the side-effect of hiding fields with NULL in the
   field, so be careful. You should probably set "default 0"
   as shown above.

  -Works for DBM types too.

  -Does NOT work for TextSearch.

  -If you want to show all records, you can pass mv_no_hide=1
   in the search parameters. Obviously, this makes this not a
   security feature.