🚀 go-pugleaf

> & Garrett writes:
> 
> Msg-ID: <1992Aug8.001154.22351@midway.uchicago.edu>
> Posted: Sat, 8 Aug 1992 00:11:54
> 
> Org.  : University of Chicago Computing Organizations
> 
> My application creates a Sybase table (using dblibrary calls) to hold some
> intermediate results that a DBModule then reads and displays in a
> DBTableView.  The problem is that I need to make the application
> multi-user, and each user will be needing to create their own such table,
> which means to distinguish them in the Sybase database I'll need to insert
> the user name or the spid or whatever into the table name.
> But this means that I can't know the table name in advance, and therefore
> can't have it in my Model or hook up my Module to it.  To set this up on
> the fly with a variable entity name looks like a nightmare.
> Any ideas on how to do this, or better yet, to get around it?
> 
> 
> Colin Garrett
> colin@delphi.bsd.uchicago.edu


Another approach might be to only have one table that allows exists in the
database then add a column to it called userid.  When you do a select to work
with the data just do a where userid = userid().



--
----------------------------------------------------------------
Steven W. Macbeth                       smacbeth@mindlink.bc.ca
Macbeth Development Corp.
Vancouver NeXT User Group Executive
----------------------------------------------------------------
"Make it look like Mail!"
"Practice random kindness, and senseless acts of beauty."