Adding Fields to main tables in SalesLogix v6.2

In older databases, the main tables are locked down, which is why we always used extension tables. However, you can get around that by setting the UserDef field in the SecTableDefs table to “T” for all records where tablename = Whatever tablename your looking at. If there’s a specific requirement for those fields to be in the main table, then we’ll temporarily make that change to the sectabledefs data to add the fields.


(New fields added this way and then bundled will come across fine on installation of the bundle).


If you run this script against the test database, you should be able to add new fields:



update sectabledefs set userdef = ‘T’ where tablename = ‘contact’


 

ABOUT THE AUTHOR

Dale Richter

Director of Training- I have worked with Customer FX since 1997

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!