Method Community

 

Method storing data in fields not listed in table

Last post 08-24-2009 3:13 PM by Joe. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 08-24-2009 2:21 PM

    • Joe
    • Top 50 Contributor
    • Joined on 08-17-2009
    • Posts 97

    Method storing data in fields not listed in table

    Hello,

    If you open up the screen "Customer List", you will find that there are 2 places on screen with fields: city / state / zip / country.

    If you then direct yourself to the tables/fields you will find that these fields do not exist (at least by this name) in the table.

    At one point i totally lost these 2 fields from my screen because i deleted them off to make room while i worked, and could not find them again in fields list - resulting in starting the screen over since i really did need those fields to be filled in the end.

    If these fields are given a different name in the table and only recognized on screen as city / state / zip / country , then this goes hand in hand with my "Minor Anoyance..." post earlier.

    If these fields are NOT recognized by any other name, then how can they be stored without existing in the table? (obviously they have to be stored somewhere or they wouldnt be retrievable).

    Thx,

    Joe

  • 08-24-2009 2:55 PM In reply to

    Re: Method storing data in fields not listed in table

    Hey Joe,

    Take a look at those fields again, they are listed under the ShipTo/BillTo Address. If you look in the field list you will find;

    Shipaddresscity, Shipaddresscountry, Shipaddresszip, Shipaddressstate

    As well as

    Billaddresscity, Billaddresscountry,billaddressstate, billaddresszip

    What you are reading on the screen is the caption set for these fields. When you remove a field from the screen, you no longer see the caption. The field would go back into the field list with its original name.

    The possibility of adding another section into the edit wizard that displays the field name as seen by the table, is something we are looking into for future updates.

     

     

  • 08-24-2009 3:13 PM In reply to

    • Joe
    • Top 50 Contributor
    • Joined on 08-17-2009
    • Posts 97

    Re: Method storing data in fields not listed in table

    Hi.

    Ahhh that's where they hid it. eheh. Didnt realize the default method screens would have fields with altered captions.

    Adding a section to the edit wizard, there's the words i was looking for =) !

    I've been asked to change the occasional field caption to something very different from its original field name. Being able to see the field name during my setting up of the screen and future revisions would be a big help!

    Thx,

    ~Joe

Page 1 of 1 (3 items)