Module Builder vs Custom Fields

sugarcrmdevelopers —  September 2, 2008 — Leave a comment

Something to watch out for when working in Module Builder are reserved database keywords. In Studio, this isn’t a problem as all the custom fields get ‘_c’ appended to their column names in order to easily distinguish them from out-of-the-box fields. In Module Builder however, fields are stored with the exact name entered, so database keywords such as “IN” “AND” “SELECT” are disallowed as a field name.  Module Builder will notify you that a field name is not allowed because it is a database reserved word.  Studio doesn’t need to give that error notification because all fields are automatically appended with the ‘_c’.

No Comments

Be the first to start the conversation!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s