DVL Software Limited
[ About | Services | Products | Search | Feedback | Support ]

PowerBuilder Tips

How many users are logged in to a database?

Back to the Tips

What we need: Basically, for our application's licensing particulars, some versions allow only a single user, others allow multiple users.  Upon startup, the application take action according to the number of users on  the database.

The solution, and much easier than I thought, I found was prompted by reading p790 of the User's Guide, Vol II.  Lots of stuff in there that let you take care of it all by yourself. No stored procedures necessary.  RTFM.

  DB_Property('Alias')       as Alias, 
  DB_Property('ConnCount')   as ConnCount, 
  DB_Property('DBNumber')    as DBNumber,
  DB_Property('File')        as File,
  DB_Property('Name')        as Name,
  DB_Property('Number')      as Number,
  DB_Property('PageSize')    as PageSize
from dummy

Back to the Tips

[ About | Services | Products | Search | Feedback | Support ]

This page last updated: Wednesday, 23 February 2000
Copyright 1997, 1998, 1999, 2000 DVL Software Limited.  All rights reserved.