Strange Table ID

cincai

Hi all,

I would like to know about the table ID convention and is there anyway from SQL that we can create a new table in object designer. Even we use the developer license also cannot remove.

A customer of mine encounter a problem where out of a sudden, the table ID increases and duplicate. We found out this problem when we try to backup the data and the system tells 'Table Data '1000000003 Payment Terms' is empty'. I neveer seen this type of ID before.

Type ID Name Caption Modified Version List Date Time BLOB Size Compiled
1 1000000003 Payment Terms Payment Terms No NAVW13.10 17/12/01 12:00:00 1408 Yes
1 1000000004 Currency Currency No NAVW14.00 15/09/04 12:00:00 18156 Yes



Thanks

kriki

It means someone started a restore but didn't finish it.
If you select the menu Tools=>Restore, Navision will ask you what to do with the restore that has not finished. You can delete it or let it continue.

cincai

Hi Kriki,

I managed to solve it based on your suggestion.


Thank you.