David Emerson
davide at dalyn.co.nz
Wed Oct 29 12:22:07 CST 2003
Thanks for your suggestions Stuart and Paul, To avoid needing to maintain a large number of users we have just set up half a dozen generic users. This means that 2 people could be logged on to the database with the same user name. In fact, in my problem situation, it is only one 'user name' that uses the temptable. David At 29/10/2003, Stuart wrote: >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