{"id":74,"date":"2013-10-01T00:03:25","date_gmt":"2013-10-01T04:03:25","guid":{"rendered":"http:\/\/access-diva.com\/blog\/?p=74"},"modified":"2018-07-04T19:33:34","modified_gmt":"2018-07-04T23:33:34","slug":"field-names-in-all-caps","status":"publish","type":"post","link":"https:\/\/access-diva.com\/blog\/?p=74","title":{"rendered":"Field Names in ALL CAPS"},"content":{"rendered":"

There will be times when inherit a database and the Field Names<\/strong> are all in capital letters.\u00a0\u00a0You want to convert them to Camel<\/strong><\/span>Case<\/strong><\/span> but when you try they revert back to all capital letters.\u00a0 Here are two different ways to handle that…1.
\na. Change the Field Name<\/strong> by adding a letter to the end of the existing Field Name, Save.
\nb. Then change the Field Name<\/strong> to Camel<\/span>Case <\/span><\/strong>and Save<\/span><\/p>\n

OR<\/p>\n

Make sure that Enable design changes for tables in Datasheet view<\/strong> is checked n order for this to work.<\/p>\n

2.
\n\u00a0\u00a0\u00a0 <\/strong>a. Open<\/strong> the Table in Datasheet View<\/strong> and the Fields Ribbon<\/strong> will appear, see below<\/p>\n

\"Fields

Fields Ribbon<\/p><\/div>\n

b. From here select Name & Caption<\/strong> and adjust the Name, click OK<\/strong> and continue until you have adjusted all the Field Names<\/strong> in the Table…<\/p>\n

\"Name

Name & Caption<\/p><\/div>\n

Note<\/strong>:\u00a0 From here you can set the same Field Properties<\/strong> that you\u00a0set if the Table<\/strong> was in Design Mode<\/strong>.<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

There will be times when inherit a database and the Field Names are all in capital letters. You want to convert them to CamelCase but when you try they revert back to all capital letters. Here are two different ways to handle that…1. a. Change the Field Name by adding a letter to the end […]<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,28],"tags":[75,54],"class_list":["post-74","post","type-post","status-publish","format-standard","hentry","category-database-design","category-tables","tag-fields","tag-table-design","odd"],"_links":{"self":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/74","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=74"}],"version-history":[{"count":4,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/74\/revisions"}],"predecessor-version":[{"id":440,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/74\/revisions\/440"}],"wp:attachment":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=74"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=74"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=74"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}