Method:Classic General Q&A

Re: Invalid Column Name

matlow99 — Tue, 12 Feb 2013 04:10:30 GMT

I deleted the screen and started over. That fixed the problem. thanks.

Re: Invalid Column Name

Method_Adam — Fri, 08 Feb 2013 15:29:50 GMT

April,

Thanks for the suggestion!

- Adam

Re: Invalid Column Name

AprilHooper — Thu, 07 Feb 2013 08:15:43 GMT

Hi Matt,

I had the same message appear when I was referencing a linked field in an Insert Record into Table action and also the Update Field in Table action. I was able to fix it by identifying the field on the table by Record ID # instead of Text.

Your situation may not be the same as mine, but I hope this helps.

April Hooper

Re: Invalid Column Name

Method_Adam — Wed, 06 Feb 2013 22:37:22 GMT

Matt,

You won't be able to delete the field since it is used in other screens. Can you exit out and make sure all screens are closed properly, and try regenerating both the contacts table and the entity table? Then sign out and sign back in again.

- Adam

Re: Invalid Column Name

matlow99 — Wed, 06 Feb 2013 19:20:40 GMT

Adam,

Yes I have regenerated the table multiple times, tried pulling the filed from another table and refreshed the screens. Can I delete the field from the contacts table and then readd the field?

Re: Invalid Column Name

Method_Adam — Wed, 06 Feb 2013 15:29:41 GMT

Matt,

Have you tried regenerating the table (opening the table and clicking "Finished Editing Fields")? Have you tried republishing the screen?

- Adam

Invalid Column Name

matlow99 — Wed, 06 Feb 2013 07:12:55 GMT

Hello Method,

I am getting an error when I try to save changes to a profile screen. "Invalid column name 'BillAddressAddr2'. Please verify this field is in the table you are trying to update.

This happens on the ContactsPortal_EditProfile Screen when I change the billing address field and click the Save Changes button it returns the error. I have gone through the whole screen looking for action errors, and checked that the field is in the table, but can't seem to find the problem.

Are you able to look at my exact account and see the problem?

Best Regards,

Matt Low