Help, I am a serious beginer

R

rcamacho

New Member
My company has made me the DB admin recently because we never really had one and with SyteLine 6 as our new ERP I am having problems trying to figure it out. If I want to do a simple thing like make sure Customer Service does not skip a field, what is the best way to enforce it. I tried using the Progress Data Dictionary and edited the field (made it mandatory and added text to the description) but I dont know what to do after commiting the chage. Compile? How?
 
When you use the Progress Data Dictionary you are actually making changes to the database schema.

After you make these changes you can then "apply" them to the database. This is an option that the Data Dictionary usually asks once you have completed your changes and exit the option.

Making a field mandatory means that the field in the table must contain data and cannot be left null or unitialised.

You may want to add database validation rules or code to execute when this field is created/updated or changed.

Be careful making changes to the database schema as some programs use CRC's to verify that the code and the database match. By changing the database schema you change that tables CRC which may have the unfortunate side effect of causing the programs that access this table to no longer work without being recompiled. As I know little about Syteline 6, I have only made general progress comments above.
 
You must log in or register to reply here.
Back
Top