--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> Your application will need to control which view it access by its
own logic.
> There is nothing in InterBase that will automate this for you.
>
> If it were me doing things here I would probably use a single stored
> procedure instead of a bunch of views. Either that or I would just
use a
> SELECT statement with an input parameter.

Sorry.....no idea! Do you mean a single parameterised stored proc to
retrieve all my queries instead of my TIB_Query SELECT statements?

SELECT statement with an input parameter? Don't think I've come
across these yet...would I find some reference to these in the IB
docs? Can they be used with a TIB_QUERY?

Sorry if I'm being dense.
Steve
>
> HTH,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: <s.beames@m...>
> To: <IBObjects@y...>
> Sent: Friday, March 16, 2001 2:05 PM
> Subject: [IBO] Switching between views?
>
>
> > Hi,
> > my program will be used by two distinct user groups. They will
> > share the same tables, but their data will be seperate, perhaps by
> > use of a DEPT CHAR(3) column in each shared table. I know I can
use
> > Views to allow each group to access their own data only, but I'm
not
> > sure how my program can dynamically switch between views in all my
> > TIB_Query SELECT statements etc, according to which group the
current
> > user is from.
> >
> > Can anyone tell me if it is possible?
> > (BCB5 / IBO 3.6Cf / Firebird 0.9.4.41 / Win95)
> >
> > Thanks,
> > Steve