Number of tables left -How to tell

Veica

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

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

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

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

Caro