mibuso.com
Home› NAV Three Tier
Options

Temp. Table & License Permission

navuser1navuser1 Member Posts: 1,329
edited 2014-10-15 in NAV Three Tier
Dear Sir,

Suppose there is a custom Table (ID 10,000) in your database & it's not permitted to access (Insert/delete/Modify) through your customer license.

But you can use its Temporary instance in your program. \:D/
Now or Never

Comments

  • Options
    tinoruijstinoruijs Member Posts: 1,226
    Can you give an example how you can use that?
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Options
    KowaKowa Member Posts: 918
    Just one example: I have used that in a customer report for collecting countless unsorted serial numbers, sorting them at runtime for a neat consecutive printout, using the temporary table as a dataitem.
    Can ease your life as a developer on quite a number of occasions (in all NAV versions, I first saw that being used in 2.01 :) )
    It does have some drawbacks too, if your customers do their own development work, as they will sometimes stumble upon these tables:
    - when they try to export modified objects for a source code merge to reconcile the production database with the test database
    - when they try to modfiy objects where you have used these unlicensed tables
    since these are not included in their license.
    Kai Kowalewski
  • Options
    tinoruijstinoruijs Member Posts: 1,226
    :-k
    And that temporary table that you're using is a customized table outside of the range of customer with the desired key you want?
    I think I get it. :)
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Options
    DenSterDenSter Member Posts: 8,304
    You can use any table as the source for a temporary record variable, whether you have it in your license or not. Used that way it's really just a programming construct, not an actual table.
    Daniel Rimmelzwaan
    RIS Plus, LLC
    MVP - Business Apps
  • Options
    KowaKowa Member Posts: 918
    tinoruijs wrote:
    And that temporary table that you're using is a customized table outside of the range of customer with the desired key you want?
    Exactly :). In my case both key and field structure were needed to give the document the required good looks.
    Just for sorting , you could use any table with an approiate key as a temporary instance , but always make sure that it really is "Temporary".
    In case you forget to set this property, the usual DELETEALL on a table with records within the license range will have disastrous consequences, so it is safer to use tables outside of the license range.
    Kai Kowalewski
Sign In or Register to comment.