Interesting Question on overlays
Hi, This is an interesting question If i do a describe on a T table and if the table is an overlaid one, will i be able to see the custom optional fields that i have created on the form? ie T1234 is an ootb table. I created overlay and added 2 fields If i do desc T1234, will i see the name of the 2 fields that i have added? I did it but was not able to view it on a desc Im using the resolved schemaid for this desc Please help me with ur valuable suggstions Regards Kiran Sent from Samsung Mobile ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Interesting Question on overlays
Personally I would never select against the T tables and always use the views – then I know you’ll definitely see your custom stuff. Regards, Andrew C. Goodall Software Engineer Development Services ago...@jcpenney.com T 972.431.1518 F 972.431.1027 jcpenney 6501 Legacy Drive Plano, TX 75024 jcp.com From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of Kiran Sent: Thursday, August 16, 2012 2:19 PM To: arslist@arslist.org Subject: Interesting Question on overlays ** Hi, This is an interesting question If i do a describe on a T table and if the table is an overlaid one, will i be able to see the custom optional fields that i have created on the form? ie T1234 is an ootb table. I created overlay and added 2 fields If i do desc T1234, will i see the name of the 2 fields that i have added? I did it but was not able to view it on a desc Im using the resolved schemaid for this desc Please help me with ur valuable suggstions Regards Kiran Sent from Samsung Mobile _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ font face=monospacesize=-3brThe information transmitted is intended only for the person or entity to which it is addressed and brmay contain confidential and/or privileged material. If the reader of this message is not the intendedbrrecipient, you are hereby notified that your access is unauthorized, and any review, dissemination,brdistribution or copying of this message including any attachments is strictly prohibited. If you are notbrthe intended recipient, please contact the sender and delete the material from any computer.br ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Interesting Question on overlays
Kiran, As someone has already mentioned, other than for your amusement and amazement, it is bad practice to access the T tables directly….. But, as it seems it is for your amusement in this question… Yes, when you create a custom field, it is added to the DB T table as a new C# column. When you access the table in base mode, you will not see it. In overlay mode, it is there. Now, you said you added two fields. Were they actual data fields? If they were display only fields, there is no DB field created so of course no new field would show up. Only real data fields would show up in the database table. Are you sure you are on the right table? It can get confusing sometimes when looking at T tables whether you are on the right table or not. And remember, you should be looking for C# (where # is the field ID) of the field NOT the field name. I hope this is useful, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kiran Sent: Thursday, August 16, 2012 12:19 PM To: arslist@ARSLIST.ORG Subject: Interesting Question on overlays ** Hi, This is an interesting question If i do a describe on a T table and if the table is an overlaid one, will i be able to see the custom optional fields that i have created on the form? ie T1234 is an ootb table. I created overlay and added 2 fields If i do desc T1234, will i see the name of the 2 fields that i have added? I did it but was not able to view it on a desc Im using the resolved schemaid for this desc Please help me with ur valuable suggstions Regards Kiran Sent from Samsung Mobile _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are