Number of tables left -How to tell

Veica · 2011-03-25

Hello, we are using NAV 5.0 SP1 and I'd like to know how I can tell how many tables I have left that I can use. I know we bought some tables (10) last year and now our new partner wants to know how many we have left. We've been using a lot of tables lately for new code and I'm pretty sure there's a way to tell how many are left but I just can't find it.

I looked in the license information but that didn't help me at all!!

Thanks in advance

Sog · 2011-03-25

Your new partner should be able to see which tables you have on partnersource.
There is a range of object ID's assigned to your 10 tables: ussually something like from 50000 to 50009
So if you see tables in your database between ID 50000 and 90000 (not sure 90+ is included) those tables should be counted and the sum should be subtracted from 10.
The license information contains this, but doesn't show it.

Belias · 2011-03-25

OBJECT Report 50093 oggetti in licenza
{
  OBJECT-PROPERTIES
  {
    Data=18/02/09;
    Ora=17.20.03;
    Modificato=S;
    Version List=;
  }
  PROPERTIES
  {
  }
  DATAITEMS
  {
    { PROPERTIES
      {
        DataItemTable=Table2000000043;
        DataItemTableView=SORTING(Object Type,Object Number)
                          WHERE(Read Permission=FILTER(<>' '),
                                Object Number=FILTER(50000..99999),
                                Object Type=FILTER(<>TableData));
        OnAfterGetRecord=BEGIN
                           IF TBObject.GET("License Permission"."Object Type",'',"License Permission"."Object Number") THEN
                             CurrReport.SKIP;
                         END;

      }
      SECTIONS
      {
        { PROPERTIES
          {
            SectionType=Header;
            PrintOnEveryPage=S;
            SectionWidth=8400;
            SectionHeight=846;
          }
          CONTROLS
          {
            { 1000000018;Label  ;7500 ;0    ;900  ;846  ;ParentControl=1000000017;
                                                         VertAlign=Bottom;
                                                         FontBold=S;
                                                         MultiLine=S }
            { 1000000016;Label  ;6450 ;0    ;900  ;846  ;ParentControl=1000000015;
                                                         VertAlign=Bottom;
                                                         FontBold=S;
                                                         MultiLine=S }
            { 1000000014;Label  ;5400 ;0    ;900  ;846  ;ParentControl=1000000013;
                                                         VertAlign=Bottom;
                                                         FontBold=S;
                                                         MultiLine=S }
            { 1000000012;Label  ;4350 ;0    ;900  ;846  ;ParentControl=1000000011;
                                                         VertAlign=Bottom;
                                                         FontBold=S;
                                                         MultiLine=S }
            { 1000000010;Label  ;3300 ;0    ;900  ;846  ;ParentControl=1000000009;
                                                         VertAlign=Bottom;
                                                         FontBold=S;
                                                         MultiLine=S }
            { 1000000008;Label  ;1800 ;0    ;1350 ;846  ;ParentControl=1000000007;
                                                         HorzAlign=Right;
                                                         VertAlign=Bottom;
                                                         FontBold=S;
                                                         MultiLine=S }
            { 1000000006;Label  ;0    ;0    ;1650 ;846  ;ParentControl=1000000005;
                                                         VertAlign=Bottom;
                                                         FontBold=S;
                                                         MultiLine=S }
          }
           }
        { PROPERTIES
          {
            SectionType=Body;
            SectionWidth=8400;
            SectionHeight=423;
          }
          CONTROLS
          {
            { 1000000005;TextBox;0    ;0    ;1650 ;423  ;SourceExpr="Object Type" }
            { 1000000007;TextBox;1800 ;0    ;1350 ;423  ;SourceExpr="Object Number" }
            { 1000000009;TextBox;3300 ;0    ;900  ;423  ;SourceExpr="Read Permission" }
            { 1000000011;TextBox;4350 ;0    ;900  ;423  ;SourceExpr="Insert Permission" }
            { 1000000013;TextBox;5400 ;0    ;900  ;423  ;SourceExpr="Modify Permission" }
            { 1000000015;TextBox;6450 ;0    ;900  ;423  ;SourceExpr="Delete Permission" }
            { 1000000017;TextBox;7500 ;0    ;900  ;423  ;SourceExpr="Execute Permission" }
          }
           }
      }
       }
  }
  REQUESTFORM
  {
    PROPERTIES
    {
      Width=9020;
      Height=3410;
    }
    CONTROLS
    {
    }
  }
  CODE
  {
    VAR
      TBObject@1000000000 : Record 2000000001;
      INTNo@1000000001 : Integer;

    BEGIN
    END.
  }
}

try this report (it's raw, don't expect a friendly printout

)
how to use:
1. save the code as text file, and change the object number so that it's a number that you can use with the license you want to test
2. import the report and compile it
3. run the report

it's a report i've in my utility repository for some time. Be sure to check a pair of objects and see if it tells you the truth (it's been a while since i used it the last time)

Veica · 2011-03-25

Thank you, I'll try the report and see if I can get the answer I need

Caro

Howdy, Stranger!

Quick Links

Categories

Number of tables left -How to tell

Answers