No of licensed users

How do i determine the no. of licensed concurrent users that is available in a database? i realised that it can be determined in the menu bar FILE → DATABASE → INFORMATION → SESSIONS, but i need to refer to that information using c/al code…

Hi, the information you need is stored in Table 2000000040 (License Information). ------cut-------- Line No. Text 20 1,100 Company 1 21 1,140 Company - unlimited 1 22 1,200 Session 10 23 1,300 Database Expansion per 100 MB 100 24 1,400 User IDs & Passwords 1 -----cut------ You can set filter/search the TEXT field to find the information you need. The numbers in the beginning of the TEXT filed are the granules. Look for granule 1200. Good luck

I figured that would be the only way to retrieve the sessions, but that would require some minor coding to get the figures 10 right? but, thanks anyway…

This should get you started : Declare LicenseInfo as a variable of this type : Table 2000000040 (License Information) LicenseInfo.RESET; LicenseInfo.SETFILTER(Text, ‘1,200 Session’); IF LicenseInfo.FIND(’-’) THEN BEGIN // Retrieve the Licenced Sessions from the Text field … …Your code here … … END;

[quote]
Originally posted by jordi79: I figured that would be the only way to retrieve the sessions, but that would require some minor coding to get the figures 10 right? but, thanks anyway…


</font id=qu Edited by - Tarek Demiati on 2001 Sep 06 05:25:29