Or... Use the Menu type of Data Dictionary in v6.x.
It is basically a "Search" menu based on some of these most common issues. Specifically there is an option to list fields for a form (yes you can use a $fieldID$ reference in the form name in the Menu definition) and return a value like <field ID>;<field name>. Then a simple active link can "split" the value on the ";" and put the Field ID number somewhere and strip it from the field to leave just the field name for the users to see too. And if you go ONE step farther..... Tools like the Special $PROCESS$ command "Application-Map-Ids-To-Names-L" could also map from DB name to the users choice of views of the form too. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. Never ascribe to malice, that which can be explained by incompetence. On 4/27/06, parikshit saxena <[EMAIL PROTECTED]> wrote: > > ** > Hi List > > Just for Info... > To get the details for the backend object tables( for scenarios like these), > information from Database reference guide > ARSystem data dictionary can be > referred. > > > Regards > Parikshit > > > [EMAIL PROTECTED] wrote: > > > ** > Hi Veeral > > Check SQL Table called "Field". This table contains'SchemaID', FieldID, > Fieldname etc. > > You can use Direct SQL to get values from this table 'Field". > > Best Regards > > Abdul Ghani MF > TIS,Wipro,Pune,India > Tel:+91-20-3910 2364 (Direct)/+91-20-22933700 Ext:52364 > Fax:+91-20-2293 4092 > Cell:+91-9850-9865-33 > > > ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veeral J Oza > Sent: Thursday, April 27, 2006 10:53 AM > To: [email protected] > Subject: Retrieve database info using active link > > > ** > Hi, > > Here is what I am trying to do, I have a menu from which I select a form > name, On selecting a form name, I have all the fields name populated on > another menu. After selecting a particular field i want to store the database > id of that field in a hidden character field. > E.g. > Menu1->MyApp:Form1 > Menu2->Form1:Fieldname > zcharfield->databaseid of fieldname selected in menu2. > > Environment: > ARS 6.3 > SQL 2000 Server > > So how do i retrieve the databaseid of the fieldname selected? > Kindly help!! > > > Regards, > Veeral Oza > > > The information contained in this electronic message and any attachments to > this message are intended for the exclusive use of the addressee(s) and may > contain proprietary, confidential or privileged information. If you are not > the intended recipient, you should not disseminate, distribute or copy this > e-mail. Please notify the sender immediately and destroy all copies of this > message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient should > check this email and any attachments for the presence of viruses. The company > accepts no liability for any damage caused by any virus transmitted by this > email. > > www.wipro.com > __20060125_______________________This posting was submitted with HTML in it___ > > The information contained in this electronic message and any attachments to > this message are intended for the exclusive use of the addressee(s) and may > contain proprietary, confidential or privileged information. If you are not > the intended recipient, you should not disseminate, distribute or copy this > e-mail. Please notify the sender immediately and destroy all copies of this > message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient should > check this email and any attachments for the presence of viruses. The company > accepts no liability for any damage caused by any virus transmitted by this > email. > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
