Method Community

 

Corrupt Screen and Table

Last post 01-05-2012 5:49 PM by jnoneiliv1. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-05-2012 10:08 AM

    • jnoneiliv1
    • Top 50 Contributor
    • Joined on 05-17-2010
    • Richmond, Virginia, USA
    • Posts 171

    Corrupt Screen and Table

    Oops, I think I've corrupted one of my tables, SalesOrderLine and/or screen.

    I deleted a couple of fields from table SalesOrderLine without First removing the fields from a screen.  Now when the screen attempts to open it says "Invalid column name 'PartIDImage'. Invalid column name 'PartIDImageFileName'. .."

    While deleting these fields, which was sucessfull since they did not have any data in them, I attempted to add the fields back, but as linked fields to fields in my Items table.  I could not exit the table edit screen and it said it was sending an e-mail to Method support.

    I've tried adding an innocuous field to the table, and making a minor change to the screen to regen the table and screen, but I'm still getting both the error when I try to launch the screen OR make a change to the table.

    How can I clear the lockups?

    James ONeil
    O. K. Foundry Co., Inc.
    1005 Commerce Rd.
    Richmond, Virginia 23224
  • 01-05-2012 10:09 AM In reply to

    • jnoneiliv1
    • Top 50 Contributor
    • Joined on 05-17-2010
    • Richmond, Virginia, USA
    • Posts 171

    Re: Corrupt Screen and Table

    Oh, and I forgot to add, the fields appear to be gone from both the table and screen, so everything "looks" clean.

    James ONeil
    O. K. Foundry Co., Inc.
    1005 Commerce Rd.
    Richmond, Virginia 23224
  • 01-05-2012 5:49 PM In reply to

    • jnoneiliv1
    • Top 50 Contributor
    • Joined on 05-17-2010
    • Richmond, Virginia, USA
    • Posts 171

    Re: Corrupt Screen and Table

    Answer

    Fixed.  Thanks for the quick response.

    James ONeil
    O. K. Foundry Co., Inc.
    1005 Commerce Rd.
    Richmond, Virginia 23224
Page 1 of 1 (3 items)