Good afternoon everyone, i am a new BAAN programmer without prior BAAN experience. i need your help to teach me how to create a new field and display the data keyin to another module.

My company does not have different environment for development and production, please kindly teach me how to create the field in a safe way as we are editting at the production server.

1) I have a session where i want to add a new data (numeric) field and a label. Where should i go to create the new field and label?

2) How should i add the label and new field?

3) How to display the valeu keyin for this field in another session?

4) Do i need to create a new field in the database (Informix)? How?


Your help is much appreciated!!! Thank you!!!!

Basic steps - I recommend doing this after hours, but that is your decision.
(1) Use maintain tables ttadv4120m000 to modify the table and insert your new field. You will need to pick the domain. Convert to runtime - no need to worry about informix. This will add the field to the table -and you can enter a label description. Log out and log back into baan to activate the new data dictionary.

(2) Use maintain sessions ttadv2100m000, goto form 2. Click maintain form. Insert your new label and table field. I am assuming the session that will be modified is Maintain session with main table. Do not forget that when adding a field to a form to maintain the field order. Under form/field order.

(3) Assuming you have source code you know go to the other session. First modify the form to include the new display field. Inside the script for this session you add a select for the new field - I assumed there was not any references between this session and the table used in (1) above. Pick one of the key fields on this session and use the after.display section to add the select to retrieve the new value. Without knowing the tables this will work.

Since you are doing this in production I recommend that this be done after hours so you do not impact users. The above steps sound easy, but it may take a while. I recommend creating a development environment - you do not have to have separate boxes. All you need is a VRC derived from your production environment. Then you can develop there and then when it is ready, promote it to production.

Good luck!!!

Thank you very much Mark, really appreciate your prompt reply!

Can you please teach me how to derive VRC from my production environment?

When i access sessions like ttadv4120m000 and ttadv2100m000, i keep on getting this message: 'current package VRC unknown'. how should i get access to this session?

Thank you!!!

Your going to need to set your user-id up as a developer. Under tools/application development/developers data you will find several sessions that need to be run to give you developers access. I do not have access to most of these sessions so I recommend reading the help on them.

As for how to derive a VRC that question is best asked in the administration forum. But before doing that I would contact the support center to get instructions or a document on how to do that.

Just a reminder - do this at your own risk in production. Again contact baan for directions on setting up the VRC. And make sure you have backups before making table changes.

Thanks Mark. For safety consideration, i would wait until our BAAN server migration complete then only i explore those things that you have taught me in our new test environment.

Thanks again !!!!