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