at the database level make a view which has the clause "where active='Y'" and choose the view. or alternatively make a stored procedure which serves the same function, and choose from the stored procedure. otherwise.... just be careful! :-)



----- Original Message ----
From: Sergio H. Gonzalez <shg_sistemas@...>
To: firebird-support@yahoogroups.com
Sent: Tuesday, July 29, 2008 3:11:43 PM
Subject: [firebird-support] hiding some records

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...

Thanks!

-s


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links






[Non-text portions of this message have been removed]