Subject Re: [ib-support] Multiple Company Data in 1 Database
Author Damian Dowling
At 15:57 27/03/2002, you wrote:
>You could create a table that is filled up in a process in the client
>application login, so the user will define the company data they want to
>see, you create a record on the session_table, the make views reference
>this table, or you could have a column in the users table that is updated
>every time the user choose a company to look for data, the make views that
>links to the user table and have a where clause that looks like this:
>Select * from atable join user on (user.companyid = atable.companyid) and
>user.login = USER
>I think this kind of approach could work.

Thanks nearly there, i would like as well, to allow a user to login several
times. At the moment i cannot think how to achieve this without a
Current_Session global field, perhaps it is something to add to Firebird 2?


Damian Dowling
IT Manager
Pallas Foods Ltd

Phone: + 353 69 20200
Fax: + 353 69 20201
Email: damian-dowling@...