>Hi all

Could someone please tell the reason for using a table versus a query.

I have 8 tables (small under 100 records) which contains static/lookup data
and controlled with a flag active or not.used in a multi user environment
(C/S). with Firebird database.

either I do an SQL active = true(IBOQuery)
or a filter = active = true (IBOTable)

which is better?why?

Thanks in advance.
Daniel