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’.

Tags: module builder, Studio

This entry was posted on Tuesday, September 2nd, 2008 at 11:06 am and is filed under Tip. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.