Subject Re: AW: [IBO] View, filter or ... ?
Author Geoff Worboys
> What If I'd have some connection filter in the connection:
> some "filterlinks" :)
> with data like "< table name> ::= < filter >" .
> I don't know if it's a practical solution in general, but
> for my situation it seems like it could be :)

If this is what you are looking for then build your own using
something like on of...

A. In the application, create a common OnPrepareSQL handler that you
will attach to all (or necessary) queries and add the necessary where
clause items based on the table name or query name.

B. Create your own derivation of TIB_Query and override SysPrepareSQL
to perform the necessary additions more generically. You could even
derive your own ib_connection with the necessary string list to read

C. Some variation or combination of the above depending on how
sophisticated you need the solution to be (which probably depends how
large/complex the application is).


Geoff Worboys
Telesis Computing