Forums

 
ForumForumPlug-in and Pla...Plug-in and Pla...MS SQL Server D...MS SQL Server D...view custom field in db tableview custom field in db table
Previous Previous
 
Next
 Disabled
New Post
 8/13/2013 4:55 PM
 

Hello

I've added a new custom field but don't know how to access this field on the db table thru sql server? I can see the value in the metadata view and the table view.  I need physical access to this custom field so I can update it with some data thru queries.

Thanks

beagile

New Post
 8/13/2013 9:52 PM
 

Custom fields are added to table with a similar name as the main base table.  Contacts are stored in the CONTACTS table and custom fields for Contacts are stored in the CONTACTS_CSTM table.  The ID_C field in the CONTACTS_CSTM table is the foreign key for the ID in the CONTACTS table.

 

Previous Previous
 
Next
 Disabled
ForumForumPlug-in and Pla...Plug-in and Pla...MS SQL Server D...MS SQL Server D...view custom field in db tableview custom field in db table