auto activate keys

nav-jktnav-jkt Member Posts: 15
Hi all,

Is there any function in Nav 4.0 to enable all keys in many tables ?
It's because in my database, only key on the first line for each table is enabled. So if I try to open those tables, I have to enable the required keys.

thanks.

Comments

  • johnson_alonsojohnson_alonso Member Posts: 690
    I will suppose don't do that. There is no means in Navision to enable all keys together once in a time. But must open the table and enable. Maybe developer toolkit can..? But you must also know if the keys activated will slower your computer.

    Rgds,
    Johnson
  • fredefrede Member Posts: 80
    This problem can appear if you import at backup but there is not room in the database.

    If you increase the database size and the choose Import backup again, Navision will ask if you would like to finish the import - and generate all keys...

    Don't know if this is the case here...

    Or else you may choose
    Regards,

    Henrik Frederiksen, Denmark
  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    BlackTiger wrote:
    Create a form based on hidden system table "Key".

    Or use this table in code.

    Great trick! Didn't know that. But it appears this system table "Key" is only available from 4.0 SP1 onwards.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • bobnavisionbobnavision Member Posts: 159
    Check Key Groups.

    May be you need some thing similar to this.
  • matteo_montanarimatteo_montanari Member Posts: 189
    BlackTiger wrote:
    Create a form based on hidden system table "Key".

    Or use this table in code.

    With "my" Solution Developer License:

    Developer Granules:

    610 Representative
    620 Product Specialist
    630 Solution Developer
    710 Partner Tools
    900 All Application Granules
    7,200 Application Builder
    7,300 Solution Developer

    Virtual Table Key is ReadOnly... there's a mistake?

    Eto
    Reno Sistemi Navision Developer
  • nav-jktnav-jkt Member Posts: 15
    frede wrote:
    This problem can appear if you import at backup but there is not room in the database.

    If you increase the database size and the choose Import backup again, Navision will ask if you would like to finish the import - and generate all keys...

    Don't know if this is the case here...

    Or else you may choose

    But I already allocate the space for this database about 2.5 GB. And after I restore the database, the space used only about 1.7 GB.
    There is no error message after I finish restore it.
    And when it almost complete do the restore, there are deleting processes. I don't know what data are deleted.
Sign In or Register to comment.