[dba-SQLServer]Linking to Local Table

Stuart McLachlan stuart at lexacorp.com.pg
Tue Oct 28 22:19:03 CST 2003


On 29 Oct 2003 at 16:46, David Emerson wrote:

> AXP adp, SQL2000
> 
> Currently I have a table of customer primary keys that is filled in from 
> the contents of a list box.  This table is then used to link to other 
> tables as a filter for processing client records.
> 
> Because the BE is in SQL, the same table is accessed by all 
> users.  However, a user often wants the selection to be maintained between 
> sessions (ie if they return to the selection screen the next day they want 
> their previous day's selection still showing.)  This excludes temporary 
> tables (I think) because the users close the program over night.
> 
> If there was a table stored on the local drives then each user could have 
> their own list of customers.
> 
> What I am unsure of is how I can a) link to the local database to fill it 
> up with the selections, and b) how I can reference that table within SQL 
> sprocs which use sql tables.
> 

As an alternative, why not including the users login_name in the table of 
customer keys, then everyone can have their own selections maintained 
until they deliberately discard/rebuild them.


-- 
Stuart McLachlan
Lexacorp Ltd
Application Development,  IT Consultancy
http://www.lexacorp.com.pg



More information about the dba-SQLServer mailing list