Active fields

Navi_Learner

Hi I try to add extra fields in the Sales Header Table with the number range up 50000(and the new number this time 50037) and the system gives me an error message 'active fields in a record may not take up more than 4000 bytes. The active fields in the Sales Header table take up 4012 bytes. You must reduce either the number or the length of the active fields.' What's the solution, expert?

Luc_VanDyck

Hey, you can even choose between 2 options: either reduce the number of the active fields, or reduce the length of the active fields ;-)

Or you can create a new table with the fields "Document Type", "Document No." and all your new fields. When creating a Sales Header record, you should also create a record in this new table. And when deleting a Sales Header record, you should also ... right .

Navi_Learner

Actually I reduce the length of the field, but it still gives the error message. I really need to add a new field to it. What shall I do?

kriki

Maybe you can also reduce the size of the other fields?

Navi_Learner

I can't reduce the others' since they all have data.

kriki

Even if they have data, you can reduce them until the point of the largest string in it.

Or can you delete some fields?

girish.joshi

You may also want to see if you can normalize the table to some degree. That would probably help.

I'm guessing that your table is this big because you have several large text fields in there -- is that correct? If so, Luc's suggestion is probably the best.

Navi_Learner

Thank you for all the response! I find one field that is not used and replace it and successfully save the table with new field. When I add the new one to the form and enter the data, another error message pops up'A label cannot be active'. I'm really frustrated. Experts, what is the solution this time? Thanks!

Savatage

Usually when when something continually goes wrong I take a step back.

Hopefully your not doing this on a LIVE system. So, The form was fine until you tried to add a new field. Then after fiddling around you realized there was a field that was not being used. So you got rid of that one and placed your NEW field on the Form. Itr worked but now you get a new error message after you enter data.

enter data into your new field?
Just opening the form?
Is that the complete message?

it's all in the details that way we don't have to grab at straws.

thanks

Navi_Learner

After I enter all the fields in the shipping tab and press ENTER, the system pops up the message. Just ignore this or do something? Do we have to active the new field and how?

Savatage

Savatage wrote:

Is that the complete message?

Navi Learner wrote:

the system pops up the message. Just ignore this or do something?

that's new to me. I'm sure this not too hard of a problem but when you give just pieces of the puzzle it get's us frustrated too.

So you're only getting this message after leaving the TAB?

Navi_Learner

Yes, it's a complete message and the system automatically kick us off the system and delete all the data of the shipping information we entered.

kriki

A wild gues (Also for me this one is new):
Somewhere you might have an ACTIVE of a label. Use the debugger to find it.
Or in the field you are leaving, you have property "NextControl" = the ID of a label. Just delete the "NextControl"-value and it should be ok.

Savatage

Navi Learner wrote:

the system pops up the message. Just ignore this or do something?

"Just Ignore This Or Do Something"

I'm glad I'm not upgrading my Navision anymore - these new messages would drive me crazy!

dleroux

Hiya "JW",

Contact the Solution Center that originally performed the very extensive modifications to your databse. They will be able to tell you the name of the table they created to hold the "overflow" from the many other additional data fields they had to add to that table (and the other related tables).

They also have a copy of your database that will have the original table layout if you do not have a way to get back to that on your own.

As to the new fields you want to add, they will have to go into that new table and since there are codeuints involved in processing that table, you will need to explain to "K" that the choices are to spring for about 34K worth of additional licenses, or hire someone who has those licenses to do the work.

BTW I think you are capable of doing the work - but the 34K for a full blown develpment licensing will buy one heck of a lot of billable hours from most any Solution Center. And this project would not take a "heck of a lot" of time.