Subject Re: [firebird-support] hiding some records
Author Thomas Steinmaurer
> Hello, I use FB2.1. Is there any way to hide (at database level) some records
> from a table. I have a quite simple scenario: selling articles marked as
> "inactive articles" And the use can choose wheter to see them or not. So far in
> every query I have for the articles table I do *WHERE ACTIVE = 'Y'* The problem
> is that in some forms I keep forgetting to add this clause and sometimes the
> inactive articles appear even if they are "hidden" in my app. So I was wandering
> if there is some way to filter that records in the database level. Something
> like adding *WHERE ACTIVE = 'Y'* to every select I perform to the article's
> table...

Create a view with the proper WHERE clause and query the view with:

select * from myview;

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions