Method:Classic General Q&A

Re: Method storing data in fields not listed in table

Joe — Mon, 24 Aug 2009 20:13:10 GMT

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

Re: Method storing data in fields not listed in table

Anonymous — Mon, 24 Aug 2009 19:55:16 GMT

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.

Method storing data in fields not listed in table

Joe — Mon, 24 Aug 2009 19:21:37 GMT

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