To create new fields in a table BBDD

Maykol · **Posted:** Fri Nov 25, 2005 6:27 pm

Is possible to create new fields in a table with a order number less than 150?

Mark Brummel · **Posted:** Fri Nov 25, 2005 6:45 pm

If you mean creating new fields in Navision tables (<50000) with fieldnumner <50000 the answer is no.

Unless you have some supernavisionlicense :mrgreen:

You can create fields with numbers between 50000 and 99999

Mark Brummel · **Posted:** Fri Nov 25, 2005 6:47 pm

Oops, I see now that this is the DOS forum! Do you mean DOS or are you posting in the wrong forum?

It is friday afternoon. :roll:

Mark Brummel · **Posted:** Fri Nov 25, 2005 7:07 pm

Well, I've just had a quick look in an old DOS database and the minimum value is indeed 150 so my guess is it's the same as the 50000 theory in the windows version.

You need a 'superlicense' to do this, I know they exist for windows but I don't reccomend using them.

Maykol · **Posted:** Sat Nov 26, 2005 5:30 pm

Is possible to have the superlicense?

Mark Brummel · **Posted:** Sat Nov 26, 2005 5:48 pm

Nope, I had one by accident. I never used it because it would only complicate things when you'dd upgrade. I don't even think I still have it.

What are you exactly trying to achieve? Why do you need this field?

Maykol · **Posted:** Mon Nov 28, 2005 10:03 am

In our Navision BBDD there are “black hole designs”. I am able to modify Field Name, Type and Length but I cannot add more fields with the order number less than 150. ](*,)

I am not thinking about deleting fields [-X

, but I would like to have the same fields and order for having “integrity” between tables. You know?!… fields number 20 are the same in the table Clients and Head Orders…

How is possible to know if I have the superlicense (“by accident”)? :whistle:

By the way I have another question, ¿What is the maximum Gb of Navision BBDD?. Making test and trials on our BBDD I see it is 2 Gb. ¿Is it the maximum? :?:

ThanKs Mark for your helping

ktvallentin · **Posted:** Thu Apr 20, 2006 10:17 am

Hi there.

The maximum database size of the old DOS version of Navision is 32GB, but your license file must allow it.

You purchased granules of 100MB each.

The thing to remember is, that the individual database files may NOT exceed 2GB each. When you expand your database beyond the 2GB "limit", you have to create a new database file. The most optimal way is to have several physical harddisks in the server and create equal sized files on each disk. Everytime you double your number of physical disks, you cut your response time in half.

Regards,
Kim

Maykol · **Posted:** Wed Apr 26, 2006 9:12 am

Thanks a lot for your help ktvallentin.

O:)

ridczak · **Posted:** Tue May 09, 2006 2:36 pm

ktvallentin wrote:

Hi there.

.... The most optimal way is to have several physical harddisks in the server and create equal sized files on each disk. Everytime you double your number of physical disks, you cut your response time in half.

Regards,
Kim

Hello,

we have our DB (3.5GB) in 3 files. Is it better to have them on a hardware RAID5 setup (3 SCSI HDDs) or just 3 separate disks? I think that RAID5 is maybe a bit slower but much safer than 3 separate disks? Is it correct?

Best Regards

mibuso.com

To create new fields in a table BBDD

Who is online