Field names for act database tables.

[zack.abedin]

Hi All,

I am new to sage act and i am porting my old data in sage. i am adding contacts, company and history. I am adding new company like this,

ActFramework framework = new ActFramework();
framework.LogOn("admin", "xxxxxxxxxxx", "xx.xxx.xxx.xx", "Sage_database");

Act.Framework.Companies.CompanyManager mgr = framework.Companies;
Act.Framework.Companies.Company comp = mgr.CreateCompany();
comp.Name = "MyCompany";
comp.Fields["TBL_COMPANY.NAME", true] = "Microsoft";
comp.Fields["TBL_COMPANY.BUSINESS_CITY", true] = "USA";
comp.Update();

I have one question here that where can i find all the field names for company, history and contact. (e.g. "TBL_COMPANY.NAM", "TBL_COMPANY.BUSINESS_CITY" )

Thanks,

[Janus]

If I understand correctly, then you here:

http://community.act.com/t5/ACT-Developer-s-Forum/TBL-CONTACT-Schema/m-p/121346#M4041

[zack.abedin]

hi,

Thanks for your help. That helped me alot.

One more question, i am using act 2013. i am unable to add comany record manager programatically. Here is my code and i get the following error:

Error: Invalid name format: MANAGEUSERID_NAME
Parameter name: realName

comp.Fields["TBL_COMPANY.BUSINESS_CITY", true] = "USA";
comp.Fields["MANAGEUSERID_NAME"] = "Nick";
comp.Fields["WEBADDRESS", true] = "www.alachisoft.com";

Thanks

[Janus]

MANAGEUSERID_NAME  is  Read-Only