auto activate keys

nav-jkt

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.

johnson_alonso

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

frede

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

Luc_VanDyck

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.

bobnavision

Check Key Groups.

May be you need some thing similar to this.

matteo_montanari

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

nav-jkt

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.