Subject Re: Switching between views?
Perhaps I could store the user ID locally, identify his/her group,
and change the logon ID to one representing the group, and then use
USER in my SELECT statements.......?

--- In IBObjects@y..., s.beames@m... wrote:
> 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
> sure how my program can dynamically switch between views in all my
> TIB_Query SELECT statements etc, according to which group the
> user is from.
> Can anyone tell me if it is possible?
> (BCB5 / IBO 3.6Cf / Firebird / Win95)
> Thanks,
> Steve