🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: comp.sys.next.programmer
2 messages
2 total messages Started by & Garrett Sat, 08 Aug 1992 00:11
DBKit: variable entity names
#498
Author: & Garrett
Date: Sat, 08 Aug 1992 00:11
14 lines
1170 bytes
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
Re: DBKit: variable entity names
#501
Author: William Shipley
Date: Sat, 08 Aug 1992 10:10
12 lines
1014 bytes
Colin Garrett writes:
> 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.

Why not just create another key field in your table which is the name of the  
user, and add a DBQualifier to your fetches to only get for the records for the  
relevant user?

-William Shipley
The Omni Group
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads